Hi Chris
is there a BLANK or EMPTY normally I use this (in German)
=wenn(oder(glätten(k13)="";glätten(M13)="");" ";K13*M13). With this
formula you get a BLANK in the cell, else you the result of the product.
wenn -> if
glätten -> trim
oder -> or
I hope the translation of the terms is right
Franz
Chris Taylor schrieb:
Hi I have a Calc file that I need help with please
I have a cell O13 that has the formula =K13*M13 output fine but what I
would like is when K13 or M13 is blank then O13 is blank
Eg
2Hrs(K13)19.26(M13)38.52(O13)
(K13) (M13) (O13)
Thanks
Chris
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
