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…


    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 *