| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
modified if equation.
Hi all.
I'm interested in doing an if equation that will have a statement inlcuded in my false answer. I.e., =if(a1=e1,"ok","Amount short by: " a1-e1) And for the false, my answer would become: Amount short by: .... Is it possible to do this? I've tried with the above form and of course it doesn't work. Thanks for your responses. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last Modified by... | Excel Discussion (Misc queries) | |||
| Last Modified | Excel Worksheet Functions | |||
| <HELP modified reference | Excel Worksheet Functions | |||
| date modified | Excel Discussion (Misc queries) | |||
| Equation Editor- problem when editing an equation | Excel Discussion (Misc queries) | |||
Threaded Mode
