Don't want the field to show FALSE on an if/then formula

**ktuimaunei** · 01-24-2013, 03:29 PM

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!

**e.isayev** · 01-24-2013, 03:38 PM

=if(y2>799999,".35",if(y2>500000,".30",if(y2>0,".25","")))

**Moo the Dog** · 01-24-2013, 03:43 PM

YOU CAN CHANGE YOUR FORMULA TO THIS:
=IF(Y2>799999,0.35,IF(Y2>500000,0.3,IF(Y2>0,0.25,"")))

OR EVEN USE SOMETHING LIKE THIS:
=IFERROR(LOOKUP(Y2,{1,500001,800000},{.25,.30,.35}),"")

- Moo

**ktuimaunei** · 01-24-2013, 03:44 PM

That didn't work......when I put your formula in, it made all the fields go to .30. Any thing else I can try?

**Moo the Dog** · 01-24-2013, 03:49 PM

I tested both eisayew's and my solutions, and they all work just fine. Not sure why your result is different, unless all of your data falls between 500001 and 799999

- Moo