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