| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What is wrong with this formula
Hi. I'm new to this formula stuff so please answer so that I can understand.
I thought I'd copied the format correctly (from Microsaft SUMIF Help) but I keep getting an error message that something is wrong. I can't see what though... The Function button seems to show that everything is correct. =SUMIF(D10+D11-D13,"0",(D10+D11-D13)*$A10) It's to display a percentage (A10) of a sum if the sum is 0. If it's <=0 then no sum is needed. Or, in fact, I'd rather display '0' in the cell. How would I do that? Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What's wrong with formula? | Excel Discussion (Misc queries) | |||
| Insert Calculated Field (wrong Qty*Price = wrong Amount) | Excel Discussion (Misc queries) | |||
| What is wrong in formula. | Excel Discussion (Misc queries) | |||
| What is wrong with formula? | Excel Worksheet Functions | |||
| What is Wrong with this formula please? | New Users to Excel | |||
Threaded Mode
