=(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.
|