Hey guys,

I need help with a formula.

I need the formula for one cell to be dependant on two other cells. For Example:

If I am creating a formula for cell b57….If cell b55 is 5 then divide cell b56 by 40 or if cell b55 is 4 then divide cell b56 by 32…The answers to these would be answer to formula provided in cell b57

By: Shane

Hi Shane

Thanks for writing. Try this formula…

`=IF(B55=5,B56/40,IF(B55=4,B56/32,""))`

This says if B55 =5 then divide B56 by 40, but if B55 = 4 then divide B56 by 32., but if it neither 5 or 4 then display blank.