Conditional formatting and If function?
 

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

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

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

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

--
HTH

Bob Phillips

"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

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.


--
dond
------------------------------------------------------------------------
dond's Profile: http://www.excelforum.com/member.php...o&userid=25477
View this thread: http://www.excelforum.com/showthread...hreadid=389300