IF OR formula with an IFERROR need....

[Alex D]

I need help, please....I want to write an IFOR formula that also accounts for error...

Example here.....% to goal is where my formula should go....

IF the AHT value is either blank or has a dash, I want the return to be NO DATA, if not, divide AHT goal by AHT, but if there's an error in % to Goal, then leave it blank....thanks for any help anyone can provide

AHT Goal	500
AHT
% to Goal

 

[Zot]

New Microsoft Excel Worksheet.xlsx
	A	B
1	AHT Goal	500
2	AHT
3	% to Goal	NO DATA
Sheet1

Cell Formulas
Range	Formula
B3	B3	=IF(ISERROR(B2/$B$1),"",IF(OR(ISBLANK(B2),B2=0),"NO DATA",B2/$B$1))

 

[Alex D]

First off, great start, THANK YOU----not working on my end.....attaching picture so you can see, there is nothing in G7, but the words "NO DATA" is not coming up.....even when I entered the "-", in cell G7, NO DATA was not the outcome....

 

[Zot]

Try enter 0. I thought Finance usually format cell to show "-" when value=0.
I wonder what is G7 cell format

 

[Fluff]

How about

=IF(OR(G7="",G7=0),"NO DATA",IF(ISERROR(G6/G7),"",G6/G7))

 

[Alex D]

Everything works now except the part where the value returned is an error, it doesnt blank the cell out, it leaves #VALUE!

#VALUE!

 

[Fluff]

Easiest option would be to change the formula in G7 so that it doesn't return that error.