View Full Version : Excel formula

Nebulous

27-04-2006, 04: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, 05: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, 06: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).

A formula in Excel must start with an equals sign.

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, 10: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, 03: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

Powered by vBulletin® Version 4.2.5 Copyright © 2018 vBulletin Solutions Inc. All rights reserved.