| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using iserror with greater than
If you custom format the cell as:
[=6]General;; you can simply use; =SUM(D2,D8) -- Regards Dave Hawley www.ozgrid.com "smandula" wrote in message ... Solution: =IF(D2+D8=6,D2+D8, "") works with any = 6 or 7 as long as the linked page shows a number such as 0 not "" which will cause a #value! So easy? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If formula: if A1 is greater than B1 and A1 is greater than zero.. | Excel Discussion (Misc queries) | |||
| IF, OR, ISERROR? | Excel Worksheet Functions | |||
| IsError help | Excel Discussion (Misc queries) | |||
| iserror help | Excel Worksheet Functions | |||
| CountIf Greater Than/Find Greater Than | Excel Programming | |||
Threaded Mode
