![]() |
|
#1
|
|||
|
|||
|
Can someone help me with this? I want to create a formula that represents the following:
IF the number in H2 is zero, then leave H2 blank (no divide by zero), but, IF the number is greater than zero, I want Excel to calculate the AVERAGE of cells C2:G2 Thanks! I really appreciate it! Also, is there a book/online tutorial that simply explains IF functions??? |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Create Chart using Categories | aschurg | Outlook | 2 | 08-21-2009 05:23 PM |
| Automatisation to create ppt-files | gruenkohl | PowerPoint | 2 | 06-25-2009 08:52 PM |
| Help for formula | dehann | Excel | 5 | 05-01-2009 10:44 AM |
Need help with a formula
|
tinkertron | Excel | 11 | 04-16-2009 11:43 PM |
Can't Create/Save/Print EPS
|
mark4man | Publisher | 2 | 11-08-2005 08:47 AM |