I am trying to come up with a formula that adds 5.00 to the total of cell (L58) if cell (F22) is selected (it is a drop down box) if cell F22 is not selected the 5.00 is not added.



Excel Order Form for a Pkg.jpg



I tried:



=IF(F22,[True], [5.00])



=SUMIF(F22,"True")



Can anyone help with this?



Thanks