ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   OrIf formula needed (https://www.excelbanter.com/excel-programming/305191-re-orif-formula-needed.html)

Brian
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


All times are GMT +1. The time now is 12:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com