formulas

[Bacchus]

I am trying to calculate the following:

=SUM(F41-25)*5%+2*1.17

f41 - 33.99

I keep on getting 2.79 when the answer is 2.86. Can someone let me in on
the right format to calculate this formula.

thanks

 

[Biff]

Hi!

Try this:

=(SUM(F41-25)*5%+2)*1.17

Returns: 2.865915

Biff

 

[Dave Peterson]

And so does:

=((F41-25)*5%+2)*1.17

(no reason for the =sum() portion.)

 

[Bacchus]

thanks all