IF with multiple conditions

[rkolenda]

I am having a hard time and hope someone can help please? 

If C4 says "DDR", I need cells C7&8 to divide by 2, and D7,8,&9 to multiply by 2. If C4 says "Walk", then I no division or multiplication needed.

Thanks in advance

[#2]

@rkolenda 

That could be like

=SUM(A4,-C4,-Q8)/(1+($C$4=5))

for C7 

=D4*2*(1+($C$4=5))

for D7

Similar for other cells.

[#3]

@rkolenda 

The actual value of C4 is 3.5 or 5; you display this as Walk or DDR by using a custom number format.

So the formula in C7 can be: =(A4-Q8)/IF(C4=5,2,1), and in D7: =D4*2*IF(C4=5,2,1)

See the attached version.

[#4]

Thank you for the help!

[#5]

@rkolenda , you are welcome