| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
help with excel cell formatting
In F5 i have the formula SUM(D5*E5) the cell is formatted for currency. When
i drag my formula it creates in every cell $0.00 this is affecting my average at the bottom. How do i keep the formula but loose the $0.00? Thank you for your help! |
|
#2
|
|||
|
|||
|
No need for SUM, you could use
=IF(OR(D5=0,E5=0),"",D5*E5) -- Regards, Peo Sjoblom "Dave O." wrote in message ... In F5 i have the formula SUM(D5*E5) the cell is formatted for currency. When i drag my formula it creates in every cell $0.00 this is affecting my average at the bottom. How do i keep the formula but loose the $0.00? Thank you for your help! |
|
#3
|
|||
|
|||
|
Hi
Try this: =IF(D5*E5<0,D5*E5,"") -- Andy. "Dave O." wrote in message ... In F5 i have the formula SUM(D5*E5) the cell is formatted for currency. When i drag my formula it creates in every cell $0.00 this is affecting my average at the bottom. How do i keep the formula but loose the $0.00? Thank you for your help! |
|
#4
|
|||
|
|||
|
Try this:
=IF(D5*E5,D5*E5,"") -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "Dave O." wrote in message ... In F5 i have the formula SUM(D5*E5) the cell is formatted for currency. When i drag my formula it creates in every cell $0.00 this is affecting my average at the bottom. How do i keep the formula but loose the $0.00? Thank you for your help! |
|
#5
|
|||
|
|||
|
If you leave the column of data as it is you can use a modified average
function to ignore the Zero values =AVERAGE(IF(F5:F50<0,F5:F50,"")) note it is array entered - Ctrl Shift Enter a cleaner result IMHO RES In F5 i have the formula SUM(D5*E5) the cell is formatted for currency. When i drag my formula it creates in every cell $0.00 this is affecting my average at the bottom. How do i keep the formula but loose the $0.00? Thank you for your help! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
| Can I copy a combo box in Excel 2002 with a relative cell link? | Excel Discussion (Misc queries) | |||
| Why won't my conditional formatting display in the cell | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| how do i set up a single cell continual entry in excel to total f. | Excel Discussion (Misc queries) | |||
Linear Mode
