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
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!?
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:
- HELP writing an Excel IF statement
- Fenix internet on bank statement - Guide
- Excel mod apk for pc - Download - Spreadsheets
- Structure should be followed while writing the body of an email - Guide
- Number to words in excel - Guide
- Application for bank statement sbi - Guide
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
Sep 30, 2009 at 09:13 PM
if you put $I$122 it remains static . but what are you trying to do????????