LinkBack URL
About LinkBacks
This one must me some if formula that
sounds to be little long
Find attached formula on b2 , assume
some numbers on a1
This one must me some if formula that
sounds to be little long
Find attached formula on b2 , assume
some numbers on a1
in B1:
=IF(A1<10,"Less 10",IF(A1<25,"0 to 25",IF(A1<50,"25 to 50",IF(A1<100,"50 to 100",IF(A1<200,"100 to 200",IF(A1<499,"Plenty 3",IF(A1<999,"Plenty 2","Plenty 1")))))))
You can use VLOOKUP or INDEX/MATCH like in this workbook.
<----- 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.
Thanks Jacc , works as needed ,
I would like pick your too also as
I needed that if , but does not write
nil on zero stock
Azumi I have marked thread close , I realised
that i can add now the nil argument after seeing
your formula
Glad to hear it works!
Glad to hear it works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks