Chris Taylor wrote:
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
In cell O13 enter the formula "=IF(K13*M13; K13*M13; "")", without the outside quotes. It says basically "IF cell K13 times cell M13 produces a value, place that value here, or else if no value, put nothing (null)in this cell" (Yeah, I know. Over simplified but it works to get the point across. ;-) )
-- Gene Y. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
