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%,7 5%,100%)

Regards,
KL


"dond" wrote in message
...

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