IF statement

R

rio

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
 
P

Pete_UK

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

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

Hope this helps.

Pete
 
S

Sharon

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
 
Top