Excel "if" function

  dads3a 16:13 28 Nov 06
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 06

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 06

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 06

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

cheers

  Simsy 17:12 28 Nov 06

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.

Huawei P10 review

1995-2015: How technology has changed the world in 20 years

An overview: What leading creative agencies are doing to improve diversity

New iPad, iPhone SE & Red iPhone 7 on sale now