11
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.

Leave a reply

Name (*)
Mail (*)
URI
Comment