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

Hi!

Try this:

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

Returns: 2.865915

Biff

"Bacchus" <(E-Mail Removed)> wrote in message
news:LYadnTzuQrHqv9_eRVn-(E-Mail Removed)...
>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
>
>

And so does:

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

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

Bacchus wrote:
>
> 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

--

Dave Peterson

thanks all




"Bacchus" <(E-Mail Removed)> wrote in message
news:LYadnTzuQrHqv9_eRVn-(E-Mail Removed)...
> 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
>
>