Menu

Formula resulting in 0

Search this Thread

Prev

Previous Post

Next Post

Next

#11

Report Post

Posted to microsoft.public.excel.misc

adodson

Posts: n/a

Default

Formula resulting in 0

sent. Thanks in advance.

"R. Choate" wrote:

If you want, you can mail it to me at without the NOSPAM part. I will take a look and see if I see
your problem.

HTH
--
RMC,CPA

"adodson" wrote in message ...
If you have 2003, I can email you the spreadsheet to look at.

"Jerry W. Lewis" wrote:

Your description is not very clear. For instance, when you remove /G7*E7
from your formula, do you get 105232 or 0?

The usual cause of SUM formulas returning zero is text cells that only look
like numbers. What do you get from =COUNT(F5:F33) ? Also does
=COUNTIF(H5:H33,"to "&B7) return what you would expect?

Jerry

"adodson" wrote:

I have a formula that looks like this:
=(F7+SUMIF(H5:H33,"to "&B7,F5:F33))/G7*E7
and reads like this:
=(79,129+17,359+1,679+2,081+4,987)/106.51%*6.51%

When I go through the evaluate formula, all of the amounts come up correct
until the very final =98800.1126654774*0.0651
It then results to 0.

I can remove the G7*E7 section of the formula and it will go:
(79129+26103) = 105232 = 0

Any ideas as to what is causing it to do this or how I can stop it?

I've tried creating a new worksheet to clear any random formatting, and it
results in the same response.

Thanks in advance for any assistance.

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
"Unable to set the Formula property of the Series class" with a tw	PeterQ	Charts and Charting in Excel	1	February 15th 06 07:37 PM
Dynamic Range with unused formula messing up x axis on dynamic graph	[email protected]	Charts and Charting in Excel	2	February 2nd 06 08:02 PM
HOW TO: In a formula, how to change the format of the resulting te	Kevin McCartney	Excel Worksheet Functions	9	January 31st 06 10:29 AM
My formula show up in the cell instead of a resulting value	Sweetetc	Excel Worksheet Functions	2	January 26th 06 11:41 PM
Formula for comparing 3 numbers and resulting in the lowest of the	tbible	Excel Worksheet Functions	2	November 18th 04 07:08 PM

All times are GMT +1. The time now is 01:23 PM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement