IF Statement

[tlc53]

Hi there,

I have written this formula but it is not working correctly

=IF(AND(F45>0,D8="Partnerhip"),F45*D14,IF(F45>0,F45))

This is what I am trying to achieve..
If F45 is more than 0, and D8 = "Partnership" then F45*D14 but if F45 is more than 0 and D8 does not equal "Partnership", return cell F45.

Can someone help me please?

Thanks!

 

[t0azt]

Re: IF Statement - Help

What happens when F45 is less than 0?

 

[Fluff]

Re: IF Statement - Help

In what way is it not working?

 

[tlc53]

Re: IF Statement - Help

If both criteria is false, then return zero.
I see I had a spelling error, s/b Partnership not Partnerhip. However, that still doesn't fix the problem.
Regardless of what D8 says (Partnership, or Company etc), it's just multiplying F45*D14 and not return F45.

Ignore - it was that spelling error! Thank you!

 

[tlc53]

Re: IF Statement - Help

Ignore! It was that pesky spelling error

Thank you

 

[t0azt]

Re: IF Statement - Help

Try writing it with if F45 is negative 0 then go from there. something like
=if(F45<0,0,if(D8="partnership",F45*D14,F45))

 

[Fluff]

Re: IF Statement - Help

It works for me, this will return 0 for the false requirement
=IF(AND(F45>0,D8="Partnership"),F45*D14,IF(F45>0,F45,0))
What do you have in F45 & D14?