Spreadsheet help!!!

A

alexm999

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
 
M

Mangus Pyke

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.
Click to expand...

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,3500,"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-
 
M

Michael

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


HTH

Michael Mitchelson
 
Top