Excel Formula for Multiple IF Function

Hi,

I hope i explain this properly, i am going to give you an example below.

If D3 = 1 to 50, D4 needs to = 1

If D3 =51 to 100, D4 needs to = 2

this continues like the above.

One thought on “Excel Formula for Multiple IF Function

  1. Kat

    Hi

    Try this

    =IF(AND(D3>=0,D3< =50),1,IF(AND(D3>=51,D3< =100),2,""))

    I hope this what you were after...?

Leave a Reply

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