Two Variable Formulas

OrangeYoda

New Member
Joined
Sep 23, 2022
Messages
17
Office Version
  1. 365
Platform
  1. Windows
Business Management homework is crushing me. I need to derive a price with two variables that impact the price field. Excel is not happy with my attempts. The 2nd variable being a percentage of the whole is my true ticking point. I have no idea how you get around this circular reference. Example:

Invoice = X
Parts = 200 x 2.25
Labor 1 = 10% of X
Labor 2 = 10 x hr
"Costs fee" = 50 x hours
Hours = 4
Profit 20%

I very much tried to get the "Mini-sheet" uploaded to the site, but couldn't get the file type to work. Propabaly a school IT setting. I did add a picture of what I'm trying to do for clarification.


1694525977946.png
 

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney
You can't upload files here but you can post a link to a file share.
Impossible to see your calculations & formulas in a picture. My attempt to replicate your issue wasn't successful.
Total938
Items200x2.25450
Labor1% of invoice (I added 10%)1031.8
Labor210x hours80
Overhead51x hours408
hours8
 
Upvote 0
I'm not sure how to link (I'm so sorry!) but I've added a screen with my formulas shown. The formula you see below accounted for two workers at a known per hour costs. Might be a little sloppy to power users, but it gets the result I needed. Now I have to figure out how to make one of those workers a percentage of the invoice total, but my Invoice amount is also and unknown based on the % labor.

How do you solve for two variables in excel? I keep getting circular references...which makes a lot of since.

1694529269603.png
 
Upvote 0
If you can't provide a link to a file share then see about using the XL2BB addin on posting toolbar. I have no idea where those numbers are located, so the likes of "B2" is of no help at all. Perhaps do the calculations in helper cells as I did then sum those in your Invoice cell?
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,181
Members
453,022
Latest member
Mohamed Magdi Tawfiq Emam

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