Forum Discussion
How do Write a formula?
Cell (G10) 137700 x Cell (G11)45% = 61965 Cell (G10) 137700 - (answer from first problem) 61965 = 75735 (answer from 2nd problem)75735 x Cell (G12) 10% = 7573.5 (answer from 2nd pr...
My fourth is just my final number rounded to the nearest tenth.
| cell G10 | 137700 |
| cell G11 | 45% |
| Cell G12 | 10% |
| Cell G13 | 68160 |
In that case in G13:
=LET(
First, G10*G11,
Second, G10-First,
Third, Second*G12,
Fourth, ROUND(Second-Third, 1),
ROUND(Fourth, -1))
Thanks works perfectly!
- Thank you. If you don't mind, I have one more I need help with.
(G14) 75740 * (G15) 1 = 75740
75740 * (G16) 1.28 = 96947.2
96947.2 * (G17) 1 = 96947.2
(G18) answer rounded to the nearest hundred
Cell G14 75740
Cell G15 1
Cell G16 1.28
Cell G17 1
Cell G18 96900- SergeiBaklan
Thanks works perfectly!
