=IF(C6>=0<=150,150000,IF(C6>=151<=160,158000))
I Need to use "OR" but im not sure how.
IF C6 is >=0 but <=150, then use 150,000
IF C6 is >=151 but <= 160, then use 158,000.
Please help!!!
=IF(C6>=0<=150,150000,IF(C6>=151<=160,158000))
I Need to use "OR" but im not sure how.
IF C6 is >=0 but <=150, then use 150,000
IF C6 is >=151 but <= 160, then use 158,000.
Please help!!!
Like this:
=IF(OR(C6>=0,C6<=150),150000,IF(OR(C6>=151,C6<=160),158000))
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Thank you!
I tried that one, the value show as "FALSE"
-------------
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
daffodil11. Thanks a lot!!. I started from zero. I see I also was missing a comma.
THANKS!!!!
If it's showing false, then it believes the value in C6 is either less than 0, or greater than 160 or text. I would bet on the last one. In a blank cell, type this formula
=ISNUMBER(C6)
If that's false, then Excel is storing your number as text. Can you upload the spreadsheet? (Go Advanced> Manage Attachments)
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
No problem, glad we could help out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks