IF Statement syntax when cells are blank

Good evening. I'm using the following function to find the percentage of hours worked (F23) to hours authorized (E23). When E23 and F23 are filled in with numbers I get a percentage as expected in L23. When E23 is filled with a number and F23 is filled with a 0, L23 is left blank as expected. When E23 and F23 are both blank the result in L23 is #DIV/0!.

I've tried unsuccessfully to adjust the following function (or would it be referred to as a formula) to return a "blank" value in L23 if E23 and F23 are blank.

Please Login or Register  to view this content.

Thanks for chiming in.

Matthew

Sarang,

Thank you very much. That did the trick.

Matthew

Originally Posted by Tony Valko

Here's another one.

=IFERROR(1/(1/(F23/E23)),"")

Tony,

That's really cool. I see that it works but I can't figure out (in English) how the heck the formula (or is it function) is doing what it's doing. Would you mind explaining? Thanks.

Matthew

Originally Posted by Tony Valko

1 divided by 1 divided by any number will equal that number. For example:

1/(1/22) = 22

1/22 = 0.0454545454545455

1/0.0454545454545455 = 22

So, when F3/E3 is any number other than 0, the formula returns that number.

When F3/E3 = 0 then 1/0 returns the #DIV/0! error.

The IFERROR function traps the error and returns a blank instead.

Tony,

Thanks for explaining the logic. Makes perfect sense. Great way to simplify an otherwise "wordy" formula.

Matthew