On Mon, 23 Mar 2009 07:55:59 -0400, Gene Young wrote: > 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. ;-) )
Thanks worked a treat --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
