Formula to Ignore a N/A if selected from a dropdown, and not break the rest of the formula

mark.gipson27746

I need to add another scenario to one of y formulas,

If one of the departments does not have to approve a certain type of change, they will choose N/A from the drop-down. So I will need the Approval Status column to IGNORE the N/A in that row. So if only 3 people needed to approve it choosing then the non approvers choose N/A and the Approval Status will still show Approved.

Thanks for the help

rjudenberg

can you do a COUNTIF of the number of approved statuses and see if its greater than your required total?

It's hard to answer without seeing your data

mark.gipson27746

HI Rjudenburg, sure send me your email address I will share the sheet with you.

Thanks

CanadaJim

Hi Mark,

You can also count the N/A's as "Approved" by adding a separate COUNTIF statement.  Something like:

IF((COUNTIF([ColumnA]#:[ColumnF]#,"N/A") + COUNTIF([ColumnA]#:[ColumnF]#,"Approved"))=6,"Approved","Not Approved")

Jim

mark.gipson27746

Hi Canada Jim, can you please send me your email so I can grant you access to take a look? thanks

CanadaJim

Hi Mark. Sent offline.