Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Dealing with FALSE and O responses to IF formulas
Maybe, you can help me with a couple of problems that I am having with an
Excel worksheet. In one case, I have an IF argument, which includes a CONCATENATE argument. It is all tied to the referenced field in the IF argument being greater than 1. If it is blank, I have written the formula to return a "" but instead it returns a FALSE. In the other case, I am trying to write an IF argument that state that, if a text field is blank or "", I want it to return a "". What I get is a 0. Any thoughts? |
#2
|
|||
|
|||
Why not share your formulas and values with us?
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Tom Atlanta" <Tom wrote in message ... Maybe, you can help me with a couple of problems that I am having with an Excel worksheet. In one case, I have an IF argument, which includes a CONCATENATE argument. It is all tied to the referenced field in the IF argument being greater than 1. If it is blank, I have written the formula to return a "" but instead it returns a FALSE. In the other case, I am trying to write an IF argument that state that, if a text field is blank or "", I want it to return a "". What I get is a 0. Any thoughts? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to find and delete all FALSE statements | Excel Discussion (Misc queries) | |||
Change datalabel font size for all chartobjects in a row | Charts and Charting in Excel |