|
|
#2
05-22-2009, 02:08 AM
|
|||
|
|||
Hope this helps some
Not knowing fully how your spreadsheet looks, so what I did is the following: At my top, I have my inputs which I would change with my needs I use Conditional Formatting to spot zeros so with your formula, I did this =IF(C6=0,(C3*C4*C5)*(C7+C8+C9),C3*C4*C5*(C6/C7+C8+C9)) which does NOT do a calculation with C6 if its value is a zero, BUT does a calculation without C6 Obviously, if I am in the ballpark with this solution, check carefully my formula Hopes this helps to get you started 
|
| Tags |
| inactivate, make invisible |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| special/escape/insertion characters in word | manojbmsce | Word | 0 | 09-25-2008 06:40 AM |
| escape characters | LadyReader | Word VBA | 0 | 09-06-2006 12:09 PM |
division zero escape?
Windows 7 32bit 
Office 2007
Threaded Mode