Nested IFs with ISNUMBER

Karlisa

New Member
Joined
Aug 7, 2019
Messages
7
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?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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")
 
Upvote 0
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
 
Last edited:
Upvote 0
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!
 
Upvote 0
too much brackets, sorry
Code:
=If(AND(ISNUMBER(AV29),ISNUMBER(AV31),ISNUMBER(AV37),ISNUMBER(AV40)),MAX(AV29,AV31,AV37,AV40)+1,"HOLD")
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top