How do you write a multiple IF formula

**fredunger** · 05-12-2012, 04:49 PM

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

**martindwilson** · 05-12-2012, 04:54 PM

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

**Spencer101** · 05-12-2012, 04:56 PM

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

**zbor** · 05-12-2012, 04:57 PM

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....

So in your case:

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

**martindwilson** · 05-12-2012, 05:17 PM

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"))))

**fredunger** · 05-12-2012, 05:42 PM

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

**Paul** · 05-13-2012, 02:09 AM

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.

**Paul** · 05-13-2012, 02:09 AM

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.