Conditional formatting and If function?

[dond]

Can this be done?
I want the value of cell g4 to depend on the text entry to cell f4

If f4 = a then g4 displays 25% value of cell c4
If f4 = b then g4 displays 50% value of cell c4
If f4 = c then g4 displays 75% value of cell c4
If f4 = d then g4 displays 100% value of cell c4

Can this be done?

[KL]

Hi,

This has nothing to do fith conditional formatting, I guess. Jut put the
pollowing formula into the cell [F4]:

=C4*CHOOSE(MATCH(F4,{"a","b","c","d"},0),25%,50%,75%,100%)

Regards,
KL


"dond" <[email protected]> wrote in message
news:[email protected]...
>
> Can this be done?
> I want the value of cell g4 to depend on the text entry to cell f4
>
> If f4 = a then g4 displays 25% value of cell c4
> If f4 = b then g4 displays 50% value of cell c4
> If f4 = c then g4 displays 75% value of cell c4
> If f4 = d then g4 displays 100% value of cell c4
>
> Can this be done?
>
>
> --
> dond
> ------------------------------------------------------------------------
> dond's Profile:
> http://www.excelforum.com/member.php...o&userid=25477
> View this thread: http://www.excelforum.com/showthread...hreadid=389300
>

[paul]

sure is!.In cell g4 type =if(F4="a",C4*.25,if
F4="b",C4*.5,if(F4="c",C4*.75,C4))). This assumes that only a b c or d will
appear in cell f4
--
paul
remove nospam for email addy!



"dond" wrote:

>
> Can this be done?
> I want the value of cell g4 to depend on the text entry to cell f4
>
> If f4 = a then g4 displays 25% value of cell c4
> If f4 = b then g4 displays 50% value of cell c4
> If f4 = c then g4 displays 75% value of cell c4
> If f4 = d then g4 displays 100% value of cell c4
>
> Can this be done?
>
>
> --
> dond
> ------------------------------------------------------------------------
> dond's Profile: http://www.excelforum.com/member.php...o&userid=25477
> View this thread: http://www.excelforum.com/showthread...hreadid=389300
>
>

[Bob Phillips]

=IF(ISNA(MATCH(F4,{"a","b","c","d"},0)),0,MATCH(F4,{"a","b","c","d"},0))*25%

--
HTH

Bob Phillips

"dond" <[email protected]> wrote in message
news:[email protected]...
>
> Can this be done?
> I want the value of cell g4 to depend on the text entry to cell f4
>
> If f4 = a then g4 displays 25% value of cell c4
> If f4 = b then g4 displays 50% value of cell c4
> If f4 = c then g4 displays 75% value of cell c4
> If f4 = d then g4 displays 100% value of cell c4
>
> Can this be done?
>
>
> --
> dond
> ------------------------------------------------------------------------
> dond's Profile:
http://www.excelforum.com/member.php...o&userid=25477
> View this thread: http://www.excelforum.com/showthread...hreadid=389300
>

[dond]

Wow, Thanks for the help, I was obviously suffering a brain fade cause I just couldn't figure it out. Really appreciate the assistance. This is one really fantastic resource, I only wish I had found it earlier.