Combined Formula - Pass result from 1st formula to 2nd which after calculating then displays the result

[Event2020]

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.

 

[Fluff]

How about

=ROUND(A1/454,2)*15

 

[awoohaw]

something like this:

Book1
	A	B	C
1	151	0.332599119	4.988986784
2	^^Variable	Divide by Constant	Multiply by Constant
3
4	Variable 1	151
5	Constant 1	454
6	Contant 2	15
7	All in One:	4.988986784
8
9	W Roundng to match you:	4.95
10	Inserting constants:	4.95
Sheet1

Cell Formulas
Range	Formula
B1	B1	=A1/454
C1	C1	=15*B1
B7	B7	=(B4/B5)*B6
B9	B9	=ROUND(B4/B5,2)*B6
B10	B10	=ROUND(B4/454,2)*15

 

[Event2020]

Thank you

Fluff and awoohaw​

for your kind suggestions.

I am going tgo go and try them both out and will report back.

 

[Event2020]

I have had a chance to try both suggestions and they both work as long as the Number in Cell A1 is 151
but if you double it to 302 so that it becomes 302/454 (on my calculator the answer is 9.9) the formulas
both return 10.05?

 

[Fluff]

You can remove the rounding, but that will then give a result of 4.99 for 151 rather than 4.95

=A1/454*15

 

[Event2020]

Ok Thanks - I will keep the rounding.

Thank you again to you both for your kind suggestions and
I am going with Fluffs solution.

 

[Fluff]

Glad we could help & thanks for the feedback.

 

[Event2020]

Fluff thank you to you and awoohaw.

I try not to ask too many questions and I only tend to do so
when I am unable to work something out by myself.

This forum never disapoints.