![]() |
#1
|
|||
|
|||
![]()
can anyone help me with how to calculate the following using excel:
n+5%=250 |
#2
|
|||
|
|||
![]()
With 250 in A1 and 0.05 in A2:
=A1/(1+A2) |
#3
|
|||
|
|||
![]()
If I understand correctly the OP is seeking to know "n" ... so wouldn't the formula be :
=A1-(A1/(1+A2)) Answer: 11.9048 |
#4
|
|||
|
|||
![]()
I literal interpretation of the Zoemoe's question would suggest that n = 250 - 5% = 249.95. But that seems to be an unlikely interpretation.
(Zoemoe: correct me if I'm wrong.) XOR's interpretation of "n + 5%" is "n plus 5% of n", which is n*(1+5%) = 250. So n = 250/(1+5%), which is 238.095238095238. That seems to be a likely interpretation, IMHO. I cannot imagine any interpretation of "n + 5% = 250" that would lead you to think it means: n + 250/(1+5%) = 250, which leads to your solution: n = 250 - 250/(1+5%). Please explain your interpretation in English(-like) terms. |
![]() |
Thread Tools | |
Display Modes | |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
prom101 | Excel | 4 | 01-20-2017 03:31 PM |
How can I create multiple Formulae Easily | Chris Waller | Excel Programming | 0 | 09-01-2016 12:25 PM |
![]() |
H28Sailor | Excel | 7 | 03-31-2013 02:26 PM |
![]() |
Friedebarth | Word | 1 | 11-30-2011 02:22 PM |
Why wont my simple formulae work? | Florish | Excel | 4 | 02-17-2009 07:33 AM |