I need E4 to be equal to 24.95 + 7.99 (shipping) +8.25% sales tax.

Do you want to apply the tax against 24.95 or (24.95+7.99)?

To apply the tax against just the 24.95:

=IF(F4="",0,ROUND(F4*1.0825,2)+7.99)

To apply the tax against 24.95+7.99:

=IF(F4="",0,ROUND((F4+7.99)*1.0825,2))

F4 is 24.95
G4 should reflect a 25% commission of that so 6.24 would be the entry in
G4.

=ROUND(F4/4,2)

Biff

"Ssuzs" wrote in message
...
Hi! I am trying to write a formula that will calculate sales tax and add
shipping charges and I am not sure how to go about it.
I need the whole column formatted this way.
Example:
F4 is 24.95
I need E4 to be equal to 24.95 + 7.99 (shipping) +8.25% sales tax.

I have one for calculating commission but how do I apply it to the entire
column?
Currently it is =SUM(F7)/4
If you have a better suggestion for that one, I would appreciate it.
Example:
F4 is 24.95
G4 should reflect a 25% commission of that so 6.24 would be the entry in
G4.

Please help!!!
Thanks soooo much!
Sabrina