Delayed

[charlie11k]

I tried to get this answered over a day ago and no one replied....here is what i have:

Column A will either have Y1, Y2, Y3 or Y4. If the sum of a range 224:264 in column E is above 10k but less than 11k, I want cell "I" respectively to see if cell A is Y1 and if so, multiply the value in cell E by 19% and put that total in cell "I". If cell A is Y2 then if the range of 224:264 is above 11k but less than 12k, I want cell E to be multiplied by 17% and that total be put in cell J. Please help?

 

[tusharm]

How is it "not working?"

That is what I am trying to say......it is not working for some reason......here is what I have:

=IF(A224="Y1",
IF(AND(SUM($E$224:$E$264)>1,SUM($E$224:$E$264)<10000),E224*20%,""))

 

[baitmaster]

replace your )) with ),"")