MWickline

Posts: n/a

Formulas not calculating correctly

How do I get formulas to calculate correctly?

I have used the following simple formula -

=T20*Z20

where t20 = =IF(N20100%,"0",K20-M20)
z20 = 917,000
n20 = 99.04%
k20=394
m20=390

When I do the math, it should total 3,668,000, yet my total in excel is
3,457,090. Why is excel calculating this incorrectly?

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
Help, Urgent Excel Formulas are not calculating	maashoff	Excel Discussion (Misc queries)	1	May 3rd 05 12:25 AM
not calculating formulas	doros	Excel Discussion (Misc queries)	4	April 5th 05 12:29 PM
Excel won't calculate my formulas correctly.	Shelfish	Excel Worksheet Functions	2	March 18th 05 05:29 PM
Formulas not calculating???	J Dizzle Fizzle	Excel Discussion (Misc queries)	1	December 31st 04 07:47 PM
calculating formulas for all workbooks in a folder	Chad	Excel Worksheet Functions	3	November 13th 04 05:22 PM

All times are GMT +1. The time now is 02:12 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us