# Excel "if" function

dads3a 16:13 28 Nov 2006
Locked

I'm just learning excel and playing about with ECDL practice papers but I keep getting stuck on the "if" function.

I'm trying to work out a function for:

Enter a formula/function in cell D15 that refers to cell A17 if G11 >£30000 or refers to cell A18 if less than £30000

The text in A17 is YES in A18 its NO

I've looked in a few places and understand the TRUE and False part but I can't find how to refer to a certain cell.

cheers

Simsy 16:52 28 Nov 2006

G11 = £30000?

You just put the cell reference... And I suspect you're approaching this from slightly the wrong angle... Do the cells A17 and A18 contain "Yes" and "No" just as a means of getting them in the formula? If so this is not needed...

I'm going to assume that if G11 = £30000 that the required response is "Yes"...

The formula you need in D15 is;

=IF(G11>=30000,"Yes","No")

Does that help?

Regards,

Simsy

Simsy 16:53 28 Nov 2006

to refer to the cells you indicate, it would be;

=IF(G11>=30000,A17,A18)

Does that help?

Regards,

Simsy

dads3a 17:01 28 Nov 2006

Beauty I had the second one you mentioned. Must have read something right.

cheers

Simsy 17:12 28 Nov 2006

That I might have misled you slightly...

Generally speaking it IS good practice to have formulae refer to cells... but only if they are likely to change... (A rate of VAT for example)...

In your specific example it seemed to me that "Yes" and "No" are pretty much constant, i.e. they are not themselves the results of formulae, but are actually typed in values....

If the "Yes" and "No" are calculated values then your approach is entirely appropriate!

Appologies for any confusion!!

Regards,

Simsy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Alienware 17 R4 2017 review

These brilliant Lego posters show just what children's imaginations are capable of

Mac power user tips and hidden tricks

Comment réinitialiser votre PC, ordinateur portable ou tablette Windows ?