| Home |
| Search |
| Today's Posts |
|
#5
|
|||
|
|||
hi roger
thanks for your input anyway. -- BD3 "Roger Govier" wrote: Hi No, I was basing it on you literally using A,B and C. In which case as each of the cell values was being offset by 3, dependent upon the lookup value, I was trying to avoid IF statements by using the fact that CODE(A) is 65, B is 66 etc, hence taking away 65 would leave you with 0 1 or 2 to multiply by 3, giving D (9+3*0)=9, (9+3*1)=12, and (9+3*2) =15. It will not work in the scenario you describe, and I can see that Stefi has posted you a correct solution with IF statements. Regards Roger Govier bigdaddy3 wrote: sorry roger when i used a,b,c it was just an example the actual item will be say weekly,monthly etc. and if that code would do the job where would it be put |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is a Drop Down box the best function to use? | Excel Discussion (Misc queries) | |||
| how do i create a find function for an excel drop list? | Excel Discussion (Misc queries) | |||
| multiple drop down lists | Excel Discussion (Misc queries) | |||
| SumIf Function using multiple criteria | Excel Worksheet Functions | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
Threaded Mode
