Error across a small range if cells are blank

[Allen_Mead]

This is my formula which works great if all cells are populated. However, when either L7 or L8 are empty I get the classic #VALUE error. How do I get the equation to ignore blank cells?

=((N5-(L7+L8))/N5*1)

 

[Special-K99]

=IF(OR(L7="",L8=""),"",((N5-(L7+L8))/N5*1))

Not sure why you have *1 in there, what purpose does that serve?

 

[steve the fish]

That shouldnt error if either of L7 or L8 are blank. There must be a formula in those cells if you think they are the cause of a value error.

 

[sandy666]

However, when either L7 or L8 are empty I get the classic VALUE! error.
=((N5-(L7+L8))/N5*1)

try: =(N5-SUM(L7,L8))/N5 - SUM() ignore blank and empty string like ""

you got error because L7 L8 contain ""

why N5*1 ?

 

[Allen_Mead]

=IF(OR(L7="",L8=""),"",((N5-(L7+L8))/N5*1))

Not sure why you have *1 in there, what purpose does that serve?

Thank you for assistance but I still get an error. the *1 was left over from a previous calculation which required it to give the correct percentage result.

What I was trying to do is work out the percentage of fee earning time for the week, N5 = total number of hours per week, L7-L8 = total of non fee earning time per week.

So for example, if I had 12 hours of the week as non fee earning, that's 30% but I need to know what the remaining time is in % i.e. 28 hours or, 70% but I need it to do it automatically. Looks like I just over complicated the equation.

 

[Allen_Mead]

try: =(N5-SUM(L7,L8))/N5 - SUM() ignore blank and empty string like ""

you got error because L7 L8 contain ""

why N5*1 ?

Thank you for your help, works spot on. Looks like I was just trying to over complicate the equation. N5*1 was a left over from a previous equation which I should have removed as it obviously doesn't do anything.

 

[sandy666]

Thank you for your help, works spot on.

You are welcome

Have a nice day

N5<>0 of course