Multiple If Statements with <>=

Hi,

I currently have a small function that works ok =IF(F2>=30,10,IF(F2<12,0,4)) This displays a number of 10, 4 or 0 depending upon the contents of cell F2.

However I need to increase the arguments so that the following are shown.

IF F2 greater than 39 then display 10
IF F2 less than 40 but greater than 29 then display 8
IF F2 less than 30 but greater than 19 then display 5
IF F2 less than 20 but greater than 12 then display 3
IF F2 less than 13 then display 0

Please can someone point me in the right direction. I have tried multiple IF statements combined with >39, >29, >19 but the function seems to halt when the first argument is completed.

Very many thanks in advance!

Paul

=if(f2>39,10,if(f2>29,8,if(f2>19,5,if(f2>12,3,0))))

Many thanks for the replies which are VERY helpful.

Both suggested functions worked perfectly.

=IF(F2>39,10,IF(F2>29,8,IF(F2>19,5,IF(F2>12,3,0)))) and =LOOKUP(F2,{0,13,20,30,40},{0,3,5,8,10})

However my next "slight" problem is the fact that F2 (which is the result of a VLOOKUP function) can return the result #N/A sometimes and if possible I would like to have these display a different cell D2 if the value is #N/A.

I tried with something like =IF(ISNA(F2),D2,H2) which did return the contents of D2 if F2 shows #N/A but I do not know how to incorporate both functions together?

Is this possible?

Thank you all again very much.

Paul

Originally Posted by pafranklin

Many thanks for the replies which are VERY helpful.

Both suggested functions worked perfectly.

=IF(F2>39,10,IF(F2>29,8,IF(F2>19,5,IF(F2>12,3,0)))) and =LOOKUP(F2,{0,13,20,30,40},{0,3,5,8,10})

However my next "slight" problem is the fact that F2 (which is the result of a VLOOKUP function) can return the result #N/A sometimes and if possible I would like to have these display a different cell D2 if the value is #N/A.

I tried with something like =IF(ISNA(F2),D2,H2) which did return the contents of D2 if F2 shows #N/A but I do not know how to incorporate both functions together?

Is this possible?

Thank you all again very much.

Paul

I wonder if anyone has any suggestions about how to combine these two functions please?
Many thanks.
Paul

start the formula if (f2="n/a",d2, if( and put in the rest

Originally Posted by Pepe Le Mokko

Perhaps

Please Login or Register  to view this content.

This works perfectly thank you!
Paul