Formula question

[hhamlinwright08]

Hi guys,

I have the following formula in cell AO

=IF(AN4="",#REF!,((IF(OR(AF4>0,AG4>0,AH4>0),100-SUM(AI4:AM4),""))*AN4))/100

I would like to adapt the formula so that if cell AN contains 'NA', then cell AO automatically says 'NA' as well.
Any help greatly appreciated!
Thanks

 

[mart37]

Maybe you can use: IFERROR(formula,"NA")
Or: IF(ISNA(formula),"NA",formula)