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!?

HELP writing an Excel IF statement
Fenix internet on bank statement - Guide
Excel if statement - Guide
An if statement nested within another if statement will produce how many possible results? - Guide
Structure should be followed while writing the body of an email - Guide
Excel date format dd.mm.yyyy - Guide

1 response

Answer 1 / 1

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????????

Similar discussions

How to use conditional format based on text?

How to calculate positions (1st,2nd,3rd...) in Excel

Similar discussions

Subscribe To Our Newsletter!