| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
OrIf formula needed
Hi Phil,
you can nest the 'If' function to get the result you are looking for.... =IF(Variables!C12 = "A1",Variables!D53,IF(Variables!C12 = "A2",Variables!D54,IF(Variables!C12 = "A3",Variables!D55,""))) Brian Phil Hageman wrote in message ... In a worksheet named "Scorecard" , I need a formula that does the following: =If((Variables!C12=âA1â,Variables!D53 )or IF(Variables!C12=âA2â,Variables!D54) or IF(Variables!C12=âA3â,Variables!D55), else âœâ) Thanks, Phil |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| Orif | Excel Discussion (Misc queries) | |||
| Little more help needed for my IF formula | Excel Discussion (Misc queries) | |||
| Formula, Help needed | Excel Worksheet Functions | |||
| OrIf formula needed | Excel Programming | |||
Hybrid Mode
