return a blank cell
 

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

If(a10,a1*4,"")
But Excel will not consider the cell to truly be blank...
************
Anne Troy
www.OfficeArticles.com

"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

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

Anne Troy wrote:
If(a10,a1*4,"")
But Excel will not consider the cell to truly be blank...

Precisely! And there are circumstances where that makes a
difference. I cannot think of an example off-hand, but I
stumble across them "all the time".

So, is there a way to get a "truly" blank cell (i.e, the
functional equivalent)?

It would be nice if there were a function called BLANKCELL().

Thank-you Biff & Anne Troy for your quick response. It solved my
problem!


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

No. There's really no way to have Excel see a blank cell when it contains a
formula...
************
Anne Troy
www.OfficeArticles.com

wrote in message
oups.com...
Anne Troy wrote:
If(a10,a1*4,"")
But Excel will not consider the cell to truly be blank...

Precisely! And there are circumstances where that makes a
difference. I cannot think of an example off-hand, but I
stumble across them "all the time".

So, is there a way to get a "truly" blank cell (i.e, the
functional equivalent)?

It would be nice if there were a function called BLANKCELL().