Good day will be easy question for most of you! How would I write this formula to calculate
Price = - 5,269+ 8,413 x Carat + 158.1 x Cut + 454 x Clarity
Carat = .51
Cut = 4
Clarity = 4
Good day will be easy question for most of you! How would I write this formula to calculate
Price = - 5,269+ 8,413 x Carat + 158.1 x Cut + 454 x Clarity
Carat = .51
Cut = 4
Clarity = 4
try
=(-5269+8413)*.51+158.1*4+454*4
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
The answer here depends on a few things...
For instance does this...
- 5,269+ 8,413 x Carat
mean take 8,413 x carat value and THEN subtract 5,269
OR
subtract 5,269 from 8,413, and THEN x the answer by carat?
maybe if you gave some dummy expected answers?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Price: D1Formula:Please Login or Register to view this content.
Carat: A1 = .51
Cut: B1 = 4
Clarity: C1 = 4
first is multiplication then sum (if no brackets)
you can change values in A1,B1 and C1 and get result in D1 as you wish
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice may result in an infraction in the future.
I have changed it for you, today. Please read the forum rules you agreed to when you joined this forum and abide by them in the future.)
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks