Formula Help

V

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.
 
B

Bob Phillips

Perhaps

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
V

Volcom

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

Any other suggestions anyone?
 
C

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?
 
Top