Forum Discussion
ShirleyWiker
Oct 10, 2024Copper Contributor
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...
HansVogelaar
Oct 10, 2024MVP
In that case in G13:
=LET(
First, G10*G11,
Second, G10-First,
Third, Second*G12,
Fourth, ROUND(Second-Third, 1),
ROUND(Fourth, -1))
ShirleyWiker
Oct 16, 2024Copper Contributor
Thanks works perfectly!