Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have an equation in A1:
=if(H1<45,"",H1) This is fine, if H1 is less than 45, then A1 stays blank. I don't want it to have a zero, because that would show up in a plot, it should be blank. But, in cell B1, I want the equation: =10+A1 This works fine if A1 has a value (<45), but it won't work if A1 has "" in it. I want: 10 + "" = 10 not: 10 + "" = #VALUE! Any suggestions without making "" be a zero? Chris |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find/replace "cr" from end of number to "-" in front of number | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Formulae or format to change a number "1" into the word "one | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
How can I convert a Number into words. Ex: "10" as "Ten" | Excel Worksheet Functions |