Remove #VALUE!

[parlay100]

I have a spreadsheet that has a SUM formula that I enter daily information on. I used the pulldown to extend the formula, but before i can enter the information it gives me to #VALUE! in the column. After the end of the day i enter the data and it formulates it changes to the correct data. It is just annoying to see a blank page with a column that has #VALUE! all the way down. I figured out how to hide the 0.00 in the other columns but not thise one.


Thank you for help in advance..

 

[MrKowz]

Just change your cell references:

=IF(K2="W",J2,IF(K2="L",-H2,IF(K2="P",0,"")))

 

[parlay100]

Thank you for your help it works perfectly...