We are using the following formula in a spreadsheet:
=IF(Y2>799999,".35",IF(Y2>500000,".30",IF(Y2>0,".25")))
I want to be able to format the entire column, but not have the blank fields show "FALSE". I want the fields to just be blank if there isn't anything in the "Y" field.
Any help would be appreciated.
Thanks!
Bookmarks