W
WAB
I need a formula that does the following; in col a1 there
is a number i.e., 154. In col b1 I want to show the
result of 200 minus 154 and then take 90% of the
remainder and add to what is in cell a1(in this case
154). Example, worksheet number 1 in cell "a1" is 154,
in cell "b1" is the result of 200-154=46x90%=41.4+154
=195.4. The number in cell a1 would change on the next
worksheet but the number is always subtracted from 200
the 90% of the difference is added to the number in cell
a1.
is a number i.e., 154. In col b1 I want to show the
result of 200 minus 154 and then take 90% of the
remainder and add to what is in cell a1(in this case
154). Example, worksheet number 1 in cell "a1" is 154,
in cell "b1" is the result of 200-154=46x90%=41.4+154
=195.4. The number in cell a1 would change on the next
worksheet but the number is always subtracted from 200
the 90% of the difference is added to the number in cell
a1.