Thread: OrIf formula needed
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Brian Brian is offline
external usenet poster
  
Posts: 3
Default 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 With QuoteReply With Quote