Nest "IF" statement

[Bridget Stacy]

I have a list of values for Jan, Feb, March and April. I
have a separate column that needs to calculate if the sum
of Jan, Feb and March is less than $15,000 and if April is
greater than $15K, I need to display the April value.

ie: If (Sum(A1:C1<15000)) AND if (D1>15000) THEN D1, ELSE 0

 

[Roger Govier]

Hi Bridget

Try
=IF(AND(SUM(A1:C1)<=15000,D1>=15000),D1,0)

 

[Frank Kabel]

Hi Bridget
try
IF(AND(SUM(A1:C1)<15000,D1>15000),D1,0)

HTH
Frank