=LOOKUP(A1,{0,0.101,1.001,2.001},{1.5,3,4,4}) or =LOOKUP(A1,{0,0.101,1.001},{1.5,3,4})
what above if it is more than 2 Kgs
=LOOKUP(A1,{0,0.101,1.001,2.001},{1.5,3,4,4}) or =LOOKUP(A1,{0,0.101,1.001},{1.5,3,4})
what above if it is more than 2 Kgs
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks