IF thread not working

[kjrst9]

Using Excel 2001 on Windows XP Pro, I have three IF formulas that I want to combine into one.

<TABLE style="WIDTH: 48pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=64><COLGROUP><COL style="WIDTH: 48pt" width=64><TBODY><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; WIDTH: 48pt; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20 width=64>IF(AND(H24>0,H23>0,A28=TRUE),MAX(500,50*H23),0)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20>IF(AND(H24>0,H23=0,A28=TRUE),0,0)</TD></TR><TR style="HEIGHT: 15pt" height=20><TD style="BORDER-BOTTOM: #d4d0c8; BORDER-LEFT: #d4d0c8; BACKGROUND-COLOR: transparent; HEIGHT: 15pt; BORDER-TOP: #d4d0c8; BORDER-RIGHT: #d4d0c8" height=20>IF(AND(H24=0,A28=TRUE),MAX(500,50*H23),0)</TD></TR></TBODY></TABLE>

Independantly each works fine. When I add them together, I get an error. I'm guessing this must be in my parentheses? Here's my string:

IF(AND(H24>0,H23>0,A28=TRUE),MAX(500,50*H23),0,IF(AND(H24>0,H23=0,A28=TRUE),0,0,IF(AND(H24=0,A28=TRUE),MAX(500,50*H23),0)))

What's wrong with it?????

 

[dave3009]

Hi and welcome

See this bit in red

IF(AND(H24>0,H23>0,A28=TRUE),MAX(500,50*H23),0,IF(AND(H24>0,H23=0,A28=TRUE),0,0,IF(AND(H24=0,A28=TRUE),MAX(500,50*H23),0)))

There only wants to be one zero

 

[CheshireCat]

Try it like this:

=IF(AND(H24>0,H23>0,A28=TRUE),MAX(500,50*H23),IF(AND(H24>0,H23=0,A28=TRUE),0,IF(AND(H24=0,A28=TRUE),MAX(500,50*H23),0)))

 

[kjrst9]

Eliminating that zero still gives me an error. (Though the intent was, true or false the answer still is zero.)

 

[tigeravatar]

kjrst9,

Give this a try:
=IF(A28=TRUE,IF(OR(H24=0,AND(H24>0,H23>0)),MAX(500,50*H23),0),0)

 

[kjrst9]

now it's staying too many arguments for the function. Is that possible?!

 

[dave3009]

Actually you have too many superfluous 0's in there

Syntax:
=IF(Condition, TRUE, FALSE)

nothing else

IF(AND(H24>0,H23>0,A28=TRUE),MAX(500,50*H23),IF(AND(H24>0,H23=0,A28=TRUE),0,IF(AND(H24=0,A28=TRUE),MAX(500,50*H23),0)))

 

[kjrst9]

tigeravatar THANK YOU!

 

[kjrst9]

Dave3009 Thanks! Both you and tiger had workable solutions!!! Much appreciated.

 

[jasonb75]

How about

=AND(A28=TRUE,OR(H24=0,AND(H24>0,H23>=0)))*MAX(500,50*H23)