| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
"False"
How do you remove the "FALSE" value in a cell. The formula I'm using is simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have a "p".
Help please, Keyrookie |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"False"
So what do you want it to return? Blank?
=IF(I7="p",G7,"") -- Regards, Peo Sjoblom "Keyrookie" wrote in message ... How do you remove the "FALSE" value in a cell. The formula I'm using is simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have a "p". Help please, Keyrookie -- Keyrookie |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"False"
=if(i7="p",g7,"whatdoyouwantinstead")
or =if(i7="p",g7,"") to make it look blank Keyrookie wrote: How do you remove the "FALSE" value in a cell. The formula I'm using is simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have a "p". Help please, Keyrookie -- Keyrookie -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
"False"
=IF(I7="p",G7,"")
-- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Keyrookie" wrote in message ... How do you remove the "FALSE" value in a cell. The formula I'm using is simple: =IF(I7="p",G7). Excel returns "FALSE" if I7 does not have a "p". Help please, Keyrookie -- Keyrookie |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
| Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
| "IF" with no "false" action - Using Text | Excel Discussion (Misc queries) | |||
| "IF" with no "false" action - Using Text | Excel Discussion (Misc queries) | |||
Hybrid Mode
