| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Add extra function to formula
=IF(E3="ZEMO",U3,0)
I need to add reference to a value in another cell also and cannot find how to do this. The above looks at cell E3 and if it contains ZEMO returns the value of cell U3. I wish to modify the above formula to only show U3 value if cell M3="ZM" If it doesn't then 0 is shown in U3. Can anybody help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro/Formula to extra data from certain rows | Excel Discussion (Misc queries) | |||
| Extra comma at the end of a function | Excel Discussion (Misc queries) | |||
| Concatenate function - keeping "displayed" extra digits | Excel Discussion (Misc queries) | |||
| extra results in the MAX function | Excel Worksheet Functions | |||
| Adding an extra validation to this formula. | Excel Discussion (Misc queries) | |||
Threaded Mode
