11
Jul
Jul
If the cell value is less than 10000 then the result is .4 if not .25 but if nothing in cell the result cell needs to be blank. The formula I have so far is =IF(F9<=10000,0.4,0.25)
Answer:
=IF(ISBLANK(F9), “”, IF(F9<=10000,.4,.25))
Unfortunately there’s no way currently for a formula to result in a blank cell. The ideal you can do is an empty string (as above), or you can use NA() instead, which will cause the cell to be ignored in some numerical functions such as charting. (Empty strings, like all text, are treated as zeros.)
Book Mark it-> del.icio.us | Reddit | Slashdot | Digg | Facebook | Technorati | Google | StumbleUpon | Window Live | Tailrank | Furl | Netscape | Yahoo | BlinkList
This entry was posted
on Friday, July 11th, 2008 at 4:08 pm and is filed under Programming.
You can follow any responses to this entry through the RSS 2.0 feed.
You can leave a response, or TrackBack URI from your own site.