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!?
Configuration: Windows XP Firefox 3.5.3 Excel 2003
Can i select excel cell if that document is scaned Change the cell color using if statement ms excel Excel "if text contains" Excel conditional formatting colour row if cell is true Excel if calculation true calculate false leave blank Excel if contains Excel if date equals Excel if statement copy data if true Excel if(and(or criteria if blank delete cell How to do if statement for drop down office 2007 How to use drop down on if statement excel 2007 If condition in excel for comparing If else if statement macro If statement in excel 2007 If statements in excel If statements in excel with dropdown lists Windows excel command to go to another worksheet and check if equal Write a script that will take a single filename as an argument and adds execute permission to the file for the user, but only if