Solved 2 step calculation in 1 cell

May 18, 2014 at 20:37:16
Specs: Windows 7
I am a fairly new user of Exel and can only do super basic stuff. How would I enter 200 - 75 x 40% in a cell?

See More: 2 step calculation in 1 cell

Report •

May 19, 2014 at 04:04:18
✔ Best Answer

You need to be aware of the standard order of operations. Excel will do multiplication/division first, then addition/subtraction. Therefore the formula above will evaluate to 170.

If you want Excel to do the subtraction first you would use parenthesis.

=(200-75)*.4 which will evaluate to 50.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question