Desktop
Using an IF formula, the result is sometimes "FALSE" versus a number. If the result is "FALSE", how can I hide only the word "False", but not the correct answer if the result is true?
Thanks so much, vc
by softcorp.us
Hello Vic...
Please provide your current formula so I can reply directly vs. guessing what you're up to.
Thanks.
-----Steve Jackson
CEO/CSA
Software Corporation (Softcorp)
http://www.softcorp.us/probono
Advanced pro bono tools and utilities free for personal use
by softcorp.us
Hello Vic...
To get blank:
=IF($B13>100000,($B13-100000)*0.3,"")
To get $0:
=IF($B13>100000,($B13-100000)*0.3,0)
It can be anything you want:
=IF($B13>100000,($B13-100000)*0.3,"WHATEVER YOU WANT")
-----Steve Jackson
CEO/CSA
Software Corporation (Softcorp)
http://www.softcorp.us/probono
Advanced pro bono tools and utilities free for personal use
by softcorp.us
Hi Lee...
I like mine better :-) :-) :-)
by softcorp.us
Hello Vic...
Since you're new to TR, be sure to rate the answers you receive and close your question when you're done. Thanks.
by vic.celadon
Current formula is this:
Cell B13 = $95000
=IF($B13>100000,($B13-100000)*0.3)
This returns the word "FALSE". I prefer it to be blank or $0.
by wlbowers
To be blank:
=IF($B13>100000,SUM($B13-100000)*0.3,"")
To be 0
=IF($B13>100000,SUM($B13-100000)*0.3,"0")
Lee
by jdclyde
Just remember what the formula does.
argument, true, false.
So using the formula the previous poster put tells it if it is not true, then do something.
=IF($B13>100000,($B13-100000)*0.3,"")
arguement true false
The only thing left is to decide if you want anything to show up or not.
NOTE: you can also use conditional formulas to have it show up as different COLORS under different situation. (from the pull down menu)
Good luck and remember that for Excel, help is your friend.
by morton82
=IF(G3=0,(VLOOKUP(A3,ADD!A:C,2,0)))
How do I get this formula not to give me a "False" return. I just want the cell to be empty
This discussion is closed to new replies.
Sort by Trending