IF function

[busybeemg]

Hi
I have the following If function but I need to add that if all of this is false then return the value that is in cell P2. Can anyone help?

=IF(Q191=4,"1",IF(Q191=3,"2",IF(Q191=2,"3",IF(Q191=1,"4",IF(Q191=5,P191)))))

Thanks

[isjones]

try:

=IF(IF(Q191=4,"1",IF(Q191=3,"2",IF(Q191=2,"3",IF(Q191=1,"4",IF(Q191=5,P191)))))=FALSE,P2, IF(Q191=4,"1",IF(Q191=3,"2",IF(Q191=2,"3",IF(Q191=1,"4",IF(Q191=5,P191))))))

[Domski]

Try:

=IF(Q191=4,"1",IF(Q191=3,"2",IF(Q191=2,"3",IF(Q191=1,"4",IF(Q191=5,P191,P2)))))

Dom

[SteveG]

Hi,

You can try this:

=IF(OR(Q191<1,Q191>5),P2,CHOOSE(Q191,Q191+3,Q191+1,Q191-1,Q191-3,Q191))

HTH

Steve

[Marcol]

Try this

Please Login or Register  to view this content.

Hope this helps

[busybeemg]

Thanks! works!