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 show but only want the arena charge to be included when there is something in that column.
The column in question is D, I've totaled the cost columns in C, E, G with the total in H where I add the $20. Would the 20 be better added in E but only if there is a number in D? what would be the formula?
| B | C | D | E | F | G | H | I | J | |
| Andrews, Susan | 2 | =B3*200 | 3 | =D3*30 | 3 | =F3*25 | =C3+E3+G3+20 | =H3-I3 | |
| Barz, Janica | 2 | =B4*200 | 4 | =D4*30 | 6 | =F4*25 | =C4+E4+G4+20 | =H4-I4 | |
| Bowman, Bonnie | 2 | =B5*200 | 3 | =D5*30 | 3 | =F5*25 | =C5+E5+G5+20 | =H5-I5 |
Change the formula in E3 to
=IF(D3="", 0, D3*303+20)
and remove the +20 from the formula in H3.
2 Replies
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...
Change the formula in E3 to
=IF(D3="", 0, D3*303+20)
and remove the +20 from the formula in H3.
