Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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(). |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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(). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Possible Lookup Table | Excel Worksheet Functions | |||
returning blank cell in criteria o | Excel Discussion (Misc queries) | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Look for change next blank cell in Range | Excel Worksheet Functions |