Forum Discussion
Solved
include a static number when a cell has an entry
Hi all. I am setting up a spreadsheet to tally entry fees for a clinic and show (horse industry). There is a $20 arena charge for those attending the show only. I have a column for attending the sho...
Change the formula in E3 to
=IF(D3="", 0, D3*303+20)
and remove the +20 from the formula in H3.
Thanks Hans...
I did figure something out by changing the formula in E3 to this: =D3*30+IF(D3,20,0)
Which i guess is pretty much the same thing...