Ahhh I'm going to break my computer!!! Please HELP

S

shadums

New Member
Joined
Jul 16, 2011
Messages
2
I am totally stuck here, here's what's going on ...

I need to make a spread sheet that will have one cell to compute the other cells on its row.

For example,
I purchase a product for $20 (cell A1)
I sell It for $100 (cell B1) and
there are $20 in Fee's associated with the transaction (cell C1)

Now I want cell D1 to give me B1 - A1 - C1 but wait there's more I want that final number to be divided by 2!

So B1-A1-C1 = $60 so divide that by 2 = $30
So I want D1 to finally compute $30

Thank you So much for your time and trouble!!!!!

Isabelle
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.
Sort by date Sort by votes
shadums said:
I am totally stuck here, here's what's going on ...

I need to make a spread sheet that will have one cell to compute the other cells on its row.

For example,
I purchase a product for $20 (cell A1)
I sell It for $100 (cell B1) and
there are $20 in Fee's associated with the transaction (cell C1)

Now I want cell D1 to give me B1 - A1 - C1 but wait there's more I want that final number to be divided by 2!

So B1-A1-C1 = $60 so divide that by 2 = $30
So I want D1 to finally compute $30

Thank you So much for your time and trouble!!!!!

Isabelle
Click to expand...
Try this...

=(B1-A1-C1)/2
 
Upvote 0
shadums said:
ok, that was surprisingly painless and simple ... thanks!!!!
Click to expand...
What you probably tried was:

=B1-A1-C1/2

Excel performs math operations in a particular order. This order is called precedence.

Division and multiplication have precedence over addition and subtraction.

In the above formula this is how the precedence works:

B1-A1 - C1/2

We can control the order of precedence by using parentheses.

=(B1-A1-C1)/2

Anything within the parentheses will have precedence and will be calculated first.
 
Upvote 0
"I'm going to break my computer, please help."

I recommend a hammer.
I find that just showing the hammer (I keep a nice 5lb one handy) to my computer improves both its attitude and its performance.
:)
 
Upvote 0
You must log in or register to reply here.

Similar threads

N
  • Solved
IF Statements; clarification on approach
Replies
6
Views
258
Joe4
Joe4
rjplante
  • Question Question
Directory macro not working on certain computers
Replies
4
Views
526
rjplante
rjplante
B
  • Question Question
Function (using VBA macro) Runs Too Frequently
Replies
4
Views
378
Alex Blakenburg
A
S
  • Question Question
Multiple Conditions - Greater than less than
Replies
6
Views
1K
Peter_SSs
Peter_SSs
G
  • Question Question
Weird drag-and-drop behavior
Replies
1
Views
393
Fluff
Fluff

Forum statistics

Threads
1,224,607
Messages
6,179,871
Members
452,949
Latest member
Dupuhini

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top