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

 

[Guest]

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

 

[Bob Phillips]

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

 

[dond]

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