Home |
Search |
Today's Posts |
#1
|
|||
|
|||
excel "" in function
I am using an =if function as follows: =IF(E8"",C8*D8,"")
Right now the formula only works if E8 contains a letter, I would like it to work for a letter AND a number but cannot figure out how. Any help would be appreciated. |
#2
|
|||
|
|||
Why not
=IF(E8<"",C8*D8,"") HTH Jason Atlanta, GA -----Original Message----- I am using an =if function as follows: =IF (E8"",C8*D8,"") Right now the formula only works if E8 contains a letter, I would like it to work for a letter AND a number but cannot figure out how. Any help would be appreciated. . |
#3
|
|||
|
|||
Here is one way, =IF(ISBLANK(E8),"",C8*D8)
-- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "drisok" wrote in message ... I am using an =if function as follows: =IF(E8"",C8*D8,"") Right now the formula only works if E8 contains a letter, I would like it to work for a letter AND a number but cannot figure out how. Any help would be appreciated. |
#4
|
|||
|
|||
Assuming you mean if E8 is NOT blank/empty
=IF(E8<"",C8*D8,"") otherwise I don't know what you mean by E8 greater than "" Regards, Peo Sjoblom "drisok" wrote: I am using an =if function as follows: =IF(E8"",C8*D8,"") Right now the formula only works if E8 contains a letter, I would like it to work for a letter AND a number but cannot figure out how. Any help would be appreciated. |
#5
|
|||
|
|||
Try =IF(E8<"",C8*D8,"")
Which means "not equal" rather then "greater than" Gord Dibben Excel MVP On Wed, 29 Dec 2004 13:17:01 -0800, drisok wrote: I am using an =if function as follows: =IF(E8"",C8*D8,"") Right now the formula only works if E8 contains a letter, I would like it to work for a letter AND a number but cannot figure out how. Any help would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Access Module coded converted to Excel Function | Excel Discussion (Misc queries) | |||
Excel function help facilities | Excel Discussion (Misc queries) | |||
I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Statistical Excel Function Question within Excel 2000... | Excel Worksheet Functions |