If-Then Formula
=if(condition,action,if(condition,action,If(condit ion,action,"")))
=if(Variables!C12="A1",Variables!D52,If(Variables! C12="A2",Variables!D54,If(
.. . .
--
Regards,
Tom Ogilvy
"Phil Hageman" wrote in message
...
This is a re-post of a previous request, explained differently - I need a
single formula to do the following:
Variables is the name of a worksheet
This formula is located in another worksheet named Scorecard
If Variables!C12="A1", then populate cell with Variables!D53
If Variables!C12="A2", then populate cell with Variables!D54
If Variables!C12="A3", then populate cell with Variables!D55
If Variables!C12 is blank, then populate cell with blank.
|