Nested IFs with ISNUMBER

[Karlisa]

I am a newbie to writing anything other than a very basic Excel formula, but I need to write a formula to determine if the values in AV29, AV31, AV37 & AV40 are numbers and if they are to add one to the number with the highest value UNLESS AV40 = "N/A" in which case it would need to add one to the value of the highest number from AV29, AV31 & AV37; otherwise, put "Hold" in the cell. Here is what I have tried but doesn't work.

=If(ISNUMBER(AV29,AV31,AV37,AV40),MAX(AV29,AV31,AV37,AV40)+1,"HOLD",IF(AV40)="N/A",MAX(AV29,AV31,AV37)+1,"HOLD")

Can anyone tell me how to fix this?

 

[FormR]

Hi, pretty sure this covers all the scenarios mentioned.

=IF(AND(COUNT(AV29,AV31,AV37)=3,OR(ISNUMBER(AV40),AV40="N/A")),MAX(AV29,AV31,AV37,AV40)+1,"HOLD")

 

[sandy666]

maybe: =If(AND(ISNUMBER(AV29),ISNUMBER(AV31),ISNUMBER(AV37),ISNUMBER(AV40))),MAX(AV29,AV31,AV37,AV40)+1,"HOLD")
N/A is a text as you show
MAX() ignore text and logical
so formula should work

 

[Karlisa]

Hi, pretty sure this covers all the scenarios mentioned.

=IF(AND(COUNT(AV29,AV31,AV37)=3,OR(ISNUMBER(AV40),AV40="N/A")),MAX(AV29,AV31,AV37,AV40)+1,"HOLD")

FormR: This worked! Thank you!!

 

[Karlisa]

Sandy666: I didn't get any error messages with your formula, but the cell didn't populate so it didn't work for my purposes. Thank you for your response, though. I learned from it!

 

[sandy666]

too much brackets, sorry

=If(AND(ISNUMBER(AV29),ISNUMBER(AV31),ISNUMBER(AV37),ISNUMBER(AV40)),MAX(AV29,AV31,AV37,AV40)+1,"HOLD")