tlc53

Active Member
Joined
Jul 26, 2018
Messages
365
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!
 

Some videos you may like

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
Joined
Aug 1, 2012
Messages
134
Re: IF Statement - Help

What happens when F45 is less than 0?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,303
Office Version
  1. 365
Platform
  1. Windows
Re: IF Statement - Help

In what way is it not working?
 

tlc53

Active Member
Joined
Jul 26, 2018
Messages
365
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
Joined
Jul 26, 2018
Messages
365

ADVERTISEMENT

Re: IF Statement - Help

Ignore! It was that pesky spelling error :eek:

Thank you :)
 

t0azt

Board Regular
Joined
Aug 1, 2012
Messages
134
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
Joined
Jun 12, 2014
Messages
46,303
Office Version
  1. 365
Platform
  1. Windows
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?
 

Watch MrExcel Video

Forum statistics

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

This Week's Hot Topics

Top