| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Multiple IF functions in one?
Hi
I hope someone can help with the following little problem of calculating Column 3? Column 1 Column 2 Column 3 B16 3900 x B10 4250 x B25 6700 x B20 1200 x If Column 1 = B10 then Column 3= Column 2 * 0.000616 if not then: If Column 1 = B12 then Column 3= Column 2 * 0.000888 if not then: If Column 1 = B16 then Column 3= Column 2 * 0.001579 if not then: etc,etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple AND OR functions | Excel Worksheet Functions | |||
| Using multiple NOW functions | Excel Worksheet Functions | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| Index & Match functions - multiple criteria and multiple results | Excel Worksheet Functions | |||
| How do I use multiple functions? | Excel Worksheet Functions | |||
Threaded Mode
