| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
=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 |
|
#5
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| conditional formatting question | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| Conditional Formatting "OR" function | Excel Worksheet Functions | |||
Linear Mode
