| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
KL,
Once again Thanks. Regards Pank "KL" wrote: Hi Pank, I am assuming that as the formula is in F38 the first if would insert a value of 86.49 in F38 if the result is <110 and the second if would insert a value of 102.00 in F38 if the result is 130?. If both these test fail then the lookup is executed? Yes that's exactly it. Can you please also explain why you have dropped the TRUE statement from the lookup. if the fourth argument is ommited VLOOKUP assumes TRUE. Also, the short way of putting TRUE and FALSE as argument is 1 and 0. Regards, KL |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
