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 problem)75735 -(answer from 3rd problem) 7573.5 = 68161.5 rounded to tenth |
Cell (G13) answer from 4th problem rounded to the nearest ten |
You forgot to specify what the operator in the fourth problem is: +, -, *, /, so I used ?
=LET( First, G10*G11, Second, G10-First, Third, Second*G12, Fourth, ROUND(Second-Third, 1), ROUND(G13 ? Fourth, -1))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))
