HELP writing an Excel IF statement

Closed
syrynga Posts 1 Registration date Monday September 28, 2009 Status Member Last seen September 29, 2009 - Sep 29, 2009 at 01:04 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 30, 2009 at 09:13 PM
Hello,

I have one cell (I122) that displays the sum of a range. I'd like to change the value of cell "X" if the sum falls between value a or b. If the sum falls between c or d, I'd like value of cell"X" to display another number, etc...

Here's what I have so far (not working):

=IF(AND(i122>0,i122<99999),.15),(AND(i122>=100000,i122<174999),.16),(AND(i122>=175000,i122<249999),.17),(and(i122>249000),.18))))

Once I have a working formula, I need to make sure the cell reference to I122 remains static as I plan to copy the formula down the column.

Help PLEASE!?
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Sep 30, 2009 at 09:13 PM
if you put $I$122 it remains static . but what are you trying to do????????
1