| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is this possible in excel ?
You can't build formulas as strings like this and have excel evaluate them.
(you could create a userdefined function that could evaluate any string, though.) But I'd use something like: =B1+IF(A1="raju",1,-1)*C1 or even =B1+IF(A1="raju",C1,-C1) TUNGANA KURMA RAJU wrote: a1=raju b1=2 c1=3 d1=b1&if(a1="raju",+,-)&c1 This is not working,why?.How to do it? -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
| Open Excel 2003 from Windows Explorer | Excel Discussion (Misc queries) | |||
| Need suggestions for some uses of Ms Excel | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
| Excel 2002 and 2000 co-install. Control Which Starts ? | Excel Discussion (Misc queries) | |||
Threaded Mode
