If then formula help

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

One thought on “If then formula help

  1. andrew walker Post author

    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.

Leave a Reply

Your email address will not be published. Required fields are marked *