[sedo83]

I have problem with devide by 8, how to make answer in excell
(A1)35, (B1)8, (C1) "Answer 1", (D1) "Answer 2". I want the answer is: "Answer 1" = 4 and "Answer 2" = 3, Because 35-(8*4)=3. :4-dontkno
Thank You:wave:

[Fordy]

I don't understand what you mean, sorry.

Do you mean:


35-(8*4) is 3 yes, is that all you're trying to work out?

I don't see where 4 came into it, or what you're trying to achieve..

EDIT:
In D1, if I'm following you right you need to enter:

=SUM(A1-(B1*4))

But I don't understand what the 4 is? Where does C1 get the answer 4 from?

(If the answer in C1 IS 4, then you can change the formula in D1 to

=SUM(A1-(B1*C1))

)


Maybe a little more info and I can help you out