Formula Help

[Volcom]

Can someone please inform me what the right Excel formula would be for
the following:

=10800-(F14+F15+F17)*100?

What I'm trying to do is use 10800 to subtract the added sum of the
three cells(F14,F15,F17) and then multiply that total by 100. Please
help...thanks.

 

[Bob Phillips]

Perhaps

=(10800-(F14+F15+F17))*100

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Volcom]

Thanks for trying Bob, but that formula didn't work either.

Any other suggestions anyone?

 

[BenjieLop]

Why is Bob's formula not working? What is the answer that you ar
expecting

 

[Volcom]

Your right it does work...thanks BOB, appreciate it!

 

[comish4lif]

Excel will evaluate the expressions inside the parens first:
- in your first example - it will add F14+F15+F17
- then from 9th grade algebra, remember My Dear Aunt Sally (MDAS =
multiply, divide, add, subtract).
- excel will then multiply the value derived from F14+F15+F17 by 100
- and finally subtract that from 10800.

Now, Bob provided a formula that matched the description of what you
are trying to do. At least how I read it.

What answer do you expect? What are the values in F14+F15+F17 that we
can test?