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