Quote:
Originally Posted by Mazzaropi
I´m not sure if I understood correctly your necessity.
Try to do this one: Cell D5 -- =IF(C5="A1",10,IF(C5="B1",8,6))
If it´s not what your looking for, try explain with a worksheet example here.
|
let me check it and tell whether it works or not,. btw, i got an idea to do this using the vlookup funtion. but yours seems to be simple compared to that . let me see. thanks for the suggestion. have a nice day.