Hello,

I have searched high and low trying to find the solution but have been unable to come up with the answer. I am trying to make the below equations return blank if false, so if I have not selected one of the options the cell is blank rather than repeating false all the way down the column.

Below is the formula I'm working with.


=IF(I6="Closed Won","1",IF(I6="Closed Lost","0",IF(I6="Quote Requested",".5",IF(I6="Consultation/Site Visit",".25",IF(I6="Quote Revision",".75",IF(I6="Email",".10"))))))

Any guidance would be much appreciated!