Create a Formula that adds to a total

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

Try this :

Please Login or Register  to view this content.

I get this warning message when I insert this formula:

Circular Ref Warning.jpg

Replace L58 with the formula of Order Total. i.e. If Order Total is SUM($L$27:$L$53) Then write

Please Login or Register  to view this content.

Nope. No other formulas In that cell.

I get a value# error when I try the formula in L58.

Value Error.jpg

Then use this :

Please Login or Register  to view this content.

The dropdown box contains the words:

Institution
Bookstore
Student Pay ecommerce

I tried:

=IF(F22=Institution,Bookstore,ORStudent Pay eCommerce+5)

and

=IF(Institution,Bookstore,ORStudent Pay eCommerce(F22),5)

However neither of these work.

Please make your problem clear to us. Only answer my questions?

1. If any data is selected in dropdown then the result in L58 will be 5.
2. If no data is selected in dropdown then the result in L58 will be 0.

Are you trying to do this?

Yes that is correct.

Then my formula should work there. Please upload a sample file. May be I am missing something that I couldn't get from your description.