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]

The lightly tested *Excel formula* below goes into I224 and addresses your specific question. Hopefully, you will be able to figure out small tweaks on your own.

=IF(A224="Y1",
    IF(AND(SUM($E$224:$E$264)>10000,SUM($E$224:$E$264)<11000),E224*19%),
  IF(A224="Y2",
    IF(AND(SUM($E$224:$E$264)>11000,SUM($E$224:$E$264)<12000),E224*17%)))

 

[charlie11k]

Tusharm, the reason I want this in a macro form is so I can modify it.....learn it myself and add additional cells and range of cells. In other words........once I can see how it is done, I am going to use it for multiple other columns and rows. Thanks you for helping me thus far.

 

[charlie11k]

Let me guess........turn the macro on right? Let me see if I can figure that out first k.

 

[charlie11k]

How can I get the cell not to state "False"?

 

[tusharm]

If you want to learn how all this works, you have to try and do these kinds of changes yourself. The below is an Excel formula that goes into I224.

=IF(A224="Y1",
    IF(AND(SUM($E$224:$E$264)>10000,SUM($E$224:$E$264)<11000),E224*19%,"y1 true but sum false"),
  IF(A224="Y2",
    IF(AND(SUM($E$224:$E$264)>11000,SUM($E$224:$E$264)<12000),E224*17%,"y2 true but sum false"),"not y1 and not y2"))

How can I get the cell not to state "False"?

 

[charlie11k]

I did play around with it but could not figure it out. I tried ,"" but that did not work.......I thought I had used that in the past. If my A column is blank, my formula columns return "false". I want it to be blank, how can I do it?

 

[tusharm]

Replace the messages I included in my formula by "" (2 consecutive double quotes)

 

[charlie11k]

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%,""))

 

[charlie11k]

Can someone answer this?