Question????

[Syd]

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

 

[Frank Kabel]

Hi
why not
=BF11-(BB11<1440)*BB11

 

[Syd]

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

 

[Frank Kabel]

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,"")