# How do you write a multiple IF formula

1. ## How do you write a multiple IF formula

How do you write a conditional formula that answers for example IF A3 < B3 then B4 =B5 + B6, and IF A 3 = B3 then B4 = B5 * B7 and IF A3 > B3 then B4 = 0  Register To Reply

2. ## Re: How do you write a multiple IF formula

=if(a3<b3,b5+b6,if(a3=b3,b5*b7,0))  Register To Reply

3. ## Re: How do you write a multiple IF formula

=if(a3<b3,b5+b6,if(a3=b3,b5*b7,if(a3>b3,0)))  Register To Reply

4. ## Re: How do you write a multiple IF formula

You can nest IF functions like:

=IF(condition1, if_1_true, if_2_false)

Then second condition goes:

IF(condition1, IF(condition2, if_2_true, if_2_false), if_1_false)...

And so on....

=IF(A3<B3, B5+B6, IF(A3=B3, B5*B7, 0))  Register To Reply

5. ## Re: How do you write a multiple IF formula

further to that if your not sure lay it out like this
=if(a1=x,"its x",
if(a1=y,"its y",
if(a1=z,"its z",
if(a1=p,"its p","a1 doesn't equal anything"
join them all together
=if(a1=x,"its x",if(a1=y,"its y",if(a1=z,"its z",if(a1=p,"its p","a1 doesn't equal anything"
count the number of IFs in this case 4 and put that many ")" at the end
=if(a1=x,"its x",if(a1=y,"its y",if(a1=z,"its z",if(a1=p,"its p","a1 doesn't equal anything"))))  Register To Reply

6. ## Re: How do you write a multiple IF formula

Thanks guys!!!!! You solved this one. But I can;t figure out how to mark the thread solved  Register To Reply

7. ## Re: How do you write a multiple IF formula

You can't mark it as solved because you asked it in a sub-forum in which you're not supposed to ask questions. This is an introduction forum, hence the name.

I'll move it to another forum and then please mark it as Solved.

Thanks.  Register To Reply

8. ## Re: How do you write a multiple IF formula

You can't mark it as solved because you asked it in a sub-forum in which you're not supposed to ask questions. This is an introduction forum, hence the name.

I'll move it to another forum and then please mark it as Solved.

Thanks.  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 