Calculating Numbers

[John 4348]

Hello everyone.
On sheet 1, row A2:D2, l have numbers A2= 17, B2=97, C2= 18, D2=19, and in E2 I've written the Formula: (A2+B2*2+C2+D2*4)/8.
However, I need a formula that can supplant D2 for B2 when B2=97.

 

[6StringJazzer]

Like so

=(A2+IF(B2=97,D2,B2)*2+C2+D2*4)/8

 

[John 4348]

Thank you.
Unfortunately, not correct.

 

[Ruddles]

Are you sure your B2 is exactly 97, not just being displayed as 97?

 

[John 4348]

Like so

=(A2+IF(B2=97,D2,B2)*2+C2+D2*4)/8

Are you sure your B2 is exactly 97, not just being displayed as 97?

Yes. Sure

 

[6StringJazzer]

Unfortunately, not correct.

You're going to have be a little more specific if you want further help.

What result are you getting and what result are you expecting instead?

Using the numbers you gave in your post I get 18.625 which is the correct answer.
=(A2+IF(B2=97,D2,B2)*2+C2+D2*4)/8
Evaluates as
=(17 + IF(97=97, 19, 97)*2 + 18 + 19*4)/8
=(17 + IF(TRUE, 19, 97)*2 + 18 + 76)/8
=(17 + 19*2 + 18 + 76)/8
=(17 + 38 + 18 + 76)/8
=149/8
=18.625

$scratch.xlsm
	A	B	C	D	E
1
2	17	97	18	19	18.625
Sheet10

Cell Formulas
Range	Formula
E2	E2	=(A2+IF(B2=97,D2,B2)*2+C2+D2*4)/8

I need a formula that can supplant D2 for B2 when B2=97

To be clear, I took this to mean "use D2 if B2 is 97, otherwise use B2".

 

[John 4348]

You're going to have be a little more specific if you want further help.

What result are you getting and what result are you expecting instead?

Using the numbers you gave in your post I get 18.625 which is the correct answer.
=(A2+IF(B2=97,D2,B2)*2+C2+D2*4)/8
Evaluates as
=(17 + IF(97=97, 19, 97)*2 + 18 + 19*4)/8
=(17 + IF(TRUE, 19, 97)*2 + 18 + 76)/8
=(17 + 19*2 + 18 + 76)/8
=(17 + 38 + 18 + 76)/8
=149/8
=18.625

$scratch.xlsm
	A	B	C	D	E
1
2	17	97	18	19	18.625
Sheet10

Cell Formulas
Range	Formula
E2	E2	=(A2+IF(B2=97,D2,B2)*2+C2+D2*4)/8

To be clear, I took this to mean "use D2 if B2 is 97, otherwise use B2".

That's right.
Well done