Getting calculations to skip empty cells

[Ralexn123]

Hello,
I've been through a number of different forums and found similar questions but I haven't been able to find a solution that I can replicate.

I have inserted a formula to calculate the difference between two values. If the difference is greater than 5% then it returns a value "Reprice", if the difference is less than 5% then it returns a value of "No Action". My formula is working fine, however, I am trying to tidy it up a bit because not every cell referenced will have a value. So in the cases where there is a blank cell I would like the formula to skip that row instead of returning "#DIV/0!". The formula I am currently using is:

=IF((ABS((F3-E3)/F3)>0.05), "Reprice", "No Action")

It should be noted that the empty cells will be found in columns E and F.

Any help would be greatly appreciated.

 

[Joe4]

Welcome to the Board!

Try:

[COLOR=#333333]=IF(F3=0,"",IF((ABS((F3-E3)/F3)>0.05), "Reprice", "No Action"))[/COLOR]

 

[Ralexn123]

Thank you so much for the prompt reply Joe, that worked like a charm. I was not aware you could use a string of IF statements, I was trying to use the AND function to no avail. Thank you once again.

 

[Joe4]

You are welcome!

Yes, in most versions of Excel, you can string up to 7 levels (not that you usually want to nest quite that many, as that can get quite messy and difficult to maintain/support).