Formula Please
 

Hello from Steved

ok bare with me please.

Col A is 4000, Col B is 2000, Col C is 23,303, Col D is 26000, Col E is
$828.58
Col F is City, Col G is $0.21, Col H is 2697, Col I is $558.67

objective please is A formula please to arrive at Col I "$558.67"

Col G is arrived by dividing Col E from Col A giving "$0.21"
Col H is arrived by Minus Col D from Col C giving "2697"
Col I is arrived by Multiplying Col H And Col G giving "$558.67"

By you giving me the formula I can Delete Colums G and H

Thankyou for your patience on my Question.

=(D1-C1)*E1/A1

"Steved" wrote in message
...
Hello from Steved

ok bare with me please.

Col A is 4000, Col B is 2000, Col C is 23,303, Col D is 26000, Col E is
$828.58
Col F is City, Col G is $0.21, Col H is 2697, Col I is $558.67

objective please is A formula please to arrive at Col I "$558.67"

Col G is arrived by dividing Col E from Col A giving "$0.21"
Col H is arrived by Minus Col D from Col C giving "2697"
Col I is arrived by Multiplying Col H And Col G giving "$558.67"

By you giving me the formula I can Delete Colums G and H

Thankyou for your patience on my Question.

Thankyou

"N Harkawat" wrote:

=(D1-C1)*E1/A1

"Steved" wrote in message
...
Hello from Steved

ok bare with me please.

Col A is 4000, Col B is 2000, Col C is 23,303, Col D is 26000, Col E is
$828.58
Col F is City, Col G is $0.21, Col H is 2697, Col I is $558.67

objective please is A formula please to arrive at Col I "$558.67"

Col G is arrived by dividing Col E from Col A giving "$0.21"
Col H is arrived by Minus Col D from Col C giving "2697"
Col I is arrived by Multiplying Col H And Col G giving "$558.67"

By you giving me the formula I can Delete Colums G and H

Thankyou for your patience on my Question.