Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
=(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. |
#3
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |