I have a workbook with 2 worksheets.
Information and Table

in the worksheet Information, cell S24 if the number is greater than or
equal to $100,000 but less than $149,999 then I'd like it to put in cell
S25 the number $3000. Also if the number is between $150,000 to $199,999
i'd like it to put in $3500 in the S25 cell.

Any help would be highly appreciated...

Thanks
alex


--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=390070

On Mon, 25 Jul 2005 20:41:43 -0500, alexm999 wrote:
I have a workbook with 2 worksheets.
Information and Table

in the worksheet Information, cell S24 if the number is greater than or
equal to $100,000 but less than $149,999 then I'd like it to put in cell
S25 the number $3000. Also if the number is between $150,000 to $199,999
i'd like it to put in $3500 in the S25 cell.

Not sure what you're trying to do if the values are less than $100,000
or higher than $199,999, so I put a text-based error message of "Too
High" or "Too Low" in the formula..

=IF(S24=100000,IF(S24<149999,3000,IF(S24<199999,3 500,"Too
high")),"Too Low")

If they value is always going to be at least $100,000 and never
greater than $199,999, then you can use this:

=IF(S24<=149999,3000,3500)

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner

Hi Alex
In S25 put:
=IF(AND(S24=150000,S24<=199999),3500,IF(AND(S24= 100000,S24<=149999),3000,""))


HTH

Michael Mitchelson


"alexm999" wrote:


I have a workbook with 2 worksheets.
Information and Table

in the worksheet Information, cell S24 if the number is greater than or
equal to $100,000 but less than $149,999 then I'd like it to put in cell
S25 the number $3000. Also if the number is between $150,000 to $199,999
i'd like it to put in $3500 in the S25 cell.

Any help would be highly appreciated...

Thanks
alex


--
alexm999
------------------------------------------------------------------------
alexm999's Profile: http://www.excelforum.com/member.php...fo&userid=4918
View this thread: http://www.excelforum.com/showthread...hreadid=390070