| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help with another formula
=SUM(A7-12500)
A7 $13641.23 =SUM(A6-15998) A6 $15992.49 both formula's are backwards in reference to their answer's. A6 is coming up negative and A7 is positive. What am i doing wrong? mePenny |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with another formula
Remove "SUM" - =A7-12500
mePenny wrote: =SUM(A7-12500) A7 $13641.23 =SUM(A6-15998) A6 $15992.49 both formula's are backwards in reference to their answer's. A6 is coming up negative and A7 is positive. What am i doing wrong? mePenny |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with another formula
A7 is bigger than 12500, so the result will be positive.
155998 is bigger than A6, so the result will be negative. Maybe you want =12500-a7 and =15998-a6 ????? mePenny wrote: =SUM(A7-12500) A7 $13641.23 =SUM(A6-15998) A6 $15992.49 both formula's are backwards in reference to their answer's. A6 is coming up negative and A7 is positive. What am i doing wrong? mePenny -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with another formula
Hi,
A better formula is =A7-12500 and similar for the other one. Now if A7 contains $13641.23 why do you think it should return anyting other than a positive answer? Mike "mePenny" wrote: =SUM(A7-12500) A7 $13641.23 =SUM(A6-15998) A6 $15992.49 both formula's are backwards in reference to their answer's. A6 is coming up negative and A7 is positive. What am i doing wrong? mePenny |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with another formula
125000 is the budget. a7 has gone over.
"mePenny" wrote: =SUM(A7-12500) A7 $13641.23 =SUM(A6-15998) A6 $15992.49 both formula's are backwards in reference to their answer's. A6 is coming up negative and A7 is positive. What am i doing wrong? mePenny |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with another formula
Dave, thank you.. that is what I needed.
Thank you to everyone else.. !!! mePenny "Dave Peterson" wrote: A7 is bigger than 12500, so the result will be positive. 155998 is bigger than A6, so the result will be negative. Maybe you want =12500-a7 and =15998-a6 ????? mePenny wrote: =SUM(A7-12500) A7 $13641.23 =SUM(A6-15998) A6 $15992.49 both formula's are backwards in reference to their answer's. A6 is coming up negative and A7 is positive. What am i doing wrong? mePenny -- Dave Peterson . |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with another formula
Then =12500-A7 is what you should be doing.
mePenny wrote: 125000 is the budget. a7 has gone over. "mePenny" wrote: =SUM(A7-12500) A7 $13641.23 =SUM(A6-15998) A6 $15992.49 both formula's are backwards in reference to their answer's. A6 is coming up negative and A7 is positive. What am i doing wrong? mePenny |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
