Windows 10
Microsoft Office Pro 2019
Senario
A number is entered in cell A1 (for this example the number 151 but when in use could be any number)
In Cell B1 the formula is =A1/454 which returns 0.33
In the above formula, the number 454 is a constant in that it will always be 454 and it must be Cell A1 devided by 454
Using the return result of the formula in B1
In Cell C1 the formula is 15*0.33 which returns 4.95
In the above formula, the number 15 is a constant in that it will always be 15
Can the two formulas be combined in one cell so that the result from the first formula (in this example 0.33) is passed to the second formula which then displays the result in Cell B1 which (in this example would be 4.95)?
I know how to combine IF formulas but I do not know how to do it with these kinds of formulas.
Microsoft Office Pro 2019
Senario
A number is entered in cell A1 (for this example the number 151 but when in use could be any number)
In Cell B1 the formula is =A1/454 which returns 0.33
In the above formula, the number 454 is a constant in that it will always be 454 and it must be Cell A1 devided by 454
Using the return result of the formula in B1
In Cell C1 the formula is 15*0.33 which returns 4.95
In the above formula, the number 15 is a constant in that it will always be 15
Can the two formulas be combined in one cell so that the result from the first formula (in this example 0.33) is passed to the second formula which then displays the result in Cell B1 which (in this example would be 4.95)?
I know how to combine IF formulas but I do not know how to do it with these kinds of formulas.