| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
perform a calculation when a certain phrase appears in a cell
I am trying to build a spreadsheet to perform a arithematic when a phrase
appears in a cell (ie: Yes or NO) |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
perform a calculation when a certain phrase appears in a cell
If it is only 2 phrases use if statements, if the value you are interested in is in cell A1 and the phrases are YEs and No If(a1="Yes",the calculation if it is yes,if(a1="No","the calculation if it is no","")) Eg =if(a1="Yes", c1*d1,if(a1="No",d1*e1,"")) Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=558712 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
| data in cell not corresponding with entry | New Users to Excel | |||
| How to see calculation and heading in same cell. | Excel Discussion (Misc queries) | |||
| Perform oiperations relative to initial selected cell | Excel Discussion (Misc queries) | |||
Linear Mode
