View Single Post
  #3   Report Post  
Biff
 
Posts: n/a
Default

Hi!

Try this:

=IF(A10,A1*4,"")

Biff

"jpotts8117" wrote
in message ...

I would like to acheive a blank cell if it meets the qualification:

if the contents of the cell is greater than zero then mulitiply the
contents by 4; if the cell is empty then return an empty cell (not
0.0)

can it be done?


--
jpotts8117
------------------------------------------------------------------------
jpotts8117's Profile:
http://www.excelforum.com/member.php...o&userid=27517
View this thread: http://www.excelforum.com/showthread...hreadid=470302