# IF Statement

#### tlc53

##### Active Member
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!

### Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

#### t0azt

##### Board Regular
Re: IF Statement - Help

What happens when F45 is less than 0?

#### Fluff

##### MrExcel MVP, Moderator
Re: IF Statement - Help

In what way is it not working?

#### tlc53

##### Active Member
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!

Last edited:

#### tlc53

##### Active Member

ADVERTISEMENT

Re: IF Statement - Help

Ignore! It was that pesky spelling error

Thank you

#### t0azt

##### Board Regular
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

##### MrExcel MVP, Moderator
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?

Replies
7
Views
361
Replies
8
Views
519
Replies
1
Views
16
Replies
5
Views
104
Replies
11
Views
725

Threads
1,108,969
Messages
5,525,961
Members
409,673
Latest member
Riseee