IF statement

[Guest]

Can I put a cell content in an IF statement.
E.G. =IF(A2<=100,"a9","a10") and have it read what is in that particular
cell with each of those cells having it's own value??

Thanks

 

[Pete_UK]

Yes, but you don't have the quotes around the cell references:

=IF(A2<=100,A9,A10)

Hope this helps.

Pete

 

[Guest]

heck yea this helps.

Thanks so much you guys and gals rock

 

[Pete_UK]

Thanks for feeding back.

Pete

heck yea this helps.

Thanks so much you guys and gals rock
--
rio





- Show quoted text -

 

[Guest]

Hi anyone,

The below function is not working, it returns to zero even though N2 is less
than 7000, and q2="s" or q2="sd".

=IF(AND(N2>=7000, Q2="s"),rent_allowance*6.2%, IF(AND(N2>=7000,
Q2="sd"),rent_allowance*6.2%, 0))

The formula here should be either N2>=7000, and Q2="s" or N2>=7000, Q2="sd",
it returns a value of the rent allowance(refers to a cell) * 6.2%, otherwise
it returns a value that is false(0).

Thanks!!!!

Sharon