| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF sum is GreaterThan 0... why wont this work!?
This is what I think should work =IF((GREATERTHAN((G56-L4-N6),0)),0,(G56-L4-N6)) But it doesn't. If the sum is in minus figures I simply want the cell to display 0 Surely not that hard!? Any help much appreciated. Thanks Tan. -- Tan. ------------------------------------------------------------------------ Tan.'s Profile: http://www.excelforum.com/member.php...o&userid=30616 View this thread: http://www.excelforum.com/showthread...hreadid=502666 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
| My links no longer work . . . | Excel Discussion (Misc queries) | |||
| How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) | |||
Threaded Mode
