=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!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks