excel formula help...

  xphile 19:33 24 Mar 2007
Locked

I have the following formula in an excel sheet called "Monday", in cell B11:-
=IF(ISBLANK(B15),B10,(Staff!$D3-Monday!B15)/Staff!$D3)
Where Staff D3= 6.6 (this is hours worked btw)
If value entered in B15 6.6 the formula works great.But if value = 6.6 then I get a #DIV?# error because (6/6-6.6/6.6)=0. I want it to just show "N/A" when this is the case. I have checked microsoft help & it says to add an IF(ISERROR argument at the beginning but this doesn't seem to work either as the IF(ISERROR argument is cell B11 & thats the one my formula is in ??? Confused. Hope someone out there can decipher what I'm on about.

  xphile 19:34 24 Mar 2007

If value entered in B15 is less than 6.6 the formula works great

  xphile 19:48 24 Mar 2007

Was reading completely wrong cells & values for formula. Think it's sorted. Sorry.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

Best of the Grad Shows 2017: UAL Central Saint Martins

MacBook Pro 15-inch (2017) review

Comment connecter un MacBook à une TV ?