PDA

View Full Version : Excel formula

Nebulous
27-04-2006, 05:42 PM
What formula can I use and how can I write it in Excel to e.g.
D6X12.5%+=-E6X100÷E6

Now the answer I’m looking for is 20.145 because D6 is 4.99 and E6 is 7.03
How / or can this be done?
Thanks

godfather
27-04-2006, 06:00 PM
The maths you use don't make sense to me. Neither can I see where the intended result would come from.
Break it down into steps, perhaps and explain what you want.

I am sure it would be possible, once we understand it.

4.99 x 12.5% is either 0.62375 or if you mean +12.5% it's 5.61375

7.03 x 100 = 703, divided by 7.03 = 100.

Cant see the 20.145 though

The +=- in the middle has lost me.

Parry
27-04-2006, 07:59 PM
Hi yes, youve gone a bit astray on the math. An equal sign in the middle means the left part of the formula will be compared to the right part returning a result of either TRUE or FALSE. This is called a logical formula (a true/false result).

Multiplication X is represented by *
Division is represented by /

Lifes too short for me to try all the combinations to work out how you arrive at 20.145. A better explanation may yield an answer. :)

Lurking
02-05-2006, 11:44 AM
Nebulous you seem to know the answer okay.

It's been years since I have done any costing, but your formula looks like a What if scenario.

You appear to need a multiplication factor in there:

D5*1.125+E6*1.593277=20.145
D6*1.125*3.58851=20.145

both are to 5 decimal places.

Either way both good markups.

Lurking

ps. my brainy daughter may have a clue, if she gets time from studying.

lurks

Lurking
02-05-2006, 04:07 PM
Sorry the first D5 s/be D6

Nebulous you seem to know the answer okay.

It's been years since I have done any costing, but your formula looks like a What if scenario.

You appear to need a multiplication factor in there:

D5*1.125+E6*1.593277=20.145
D6*1.125*3.58851=20.145

both are to 5 decimal places.

Either way both good markups