Question????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to deduct the values in BB11 only if they are less that 1440

=IF(ISERROR(BF11-BB11=0," ",BF11-BB11)*(BB11<1440)*BB11)

Can some one assist in the function correction process??

Thanks
 
Thanks Frank

However, it generates the dreaded #Value! error if one of the cells involved are blank. It should work fine, other than the #Value! error


----- Frank Kabel wrote: ----

H
why no
=BF11-(BB11<1440)*BB1

--
Regard
Frank Kabe
Frankfurt, German


Syd wrote
 
Hi
I assume the cells are not really blank but may contain a value like ""
or a space. you may wrap this formula in a ISERROR function call:
=IF(ISERROR(BF11-(BB11<1440)*BB11),"",BF11-(BB11<1440)*BB11)

or check
=IF(AND(BF11<>"",BB11<>""),BF11-(BB11<1440)*BB11,"")
 
Back
Top