Help with explaining this formula, Please

Get_Involved

Active Member
Joined
Jan 26, 2007
Messages
383
With this formula, why can’t I use the cell example (F7), instead of (65%), when F7 = 10% is where it is?

It gives me the correct answer written this way.

Code:
=ROUND((A2+10%*A2)/65%,2)

Thanks in advance.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.
How about
=ROUND((A2*1.1)/F2,2)
 
Upvote 0

Excel 2010
ABCDE
110%65%
21,000.001,692.311,692.31
3
3b
Cell Formulas
RangeFormula
B2=ROUND((A2+10%*A2)/65%,2)
C2=ROUND((A2+D1*A2)/E1,2)



What are your trying to calculate?
What is the correct answer?
Did you try using Excel's Formula Evaluate?
 
Upvote 0
With this formula, why can’t I use the cell example (F7), instead of (65%), when F7 = 10% is where it is?
It gives me the correct answer written this way.
=ROUND((A2+10%*A2)/65%,2)

We don't know; you tell us(!). After 345 posts, I think that you should know how to ask a question about formula behavior by now, in order to get the quickest and most applicable response.

At a minimum, explain "why can't I?". Do you get an Excel error (e.g. #VALUE ); if so, which one? Do you simply get an unexpected result; if so, what value? Show us your original formula; the one that does not work. And show us all values, ideally displayed with up to 15 significant digits. Copy-and-paste the formula from the Formula Bar. If you retype it into your posting, you might inadvertently correct the mistake that you have in the Excel file.

IF F7 is 10%, obviously you cannot use F7 in place of 65%.

If F7 is 10% and G7 is 65%, you could write simply:

=ROUND(A2*(1+F7)/G7, 2)
 
Last edited:
Upvote 0
Glad we could help & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,521
Messages
6,114,104
Members
448,548
Latest member
harryls

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