Posted to microsoft.public.excel.misc

external usenet poster

Posts: 5

Why doesn't this formula work, please?

=IF(D26-F265,MIN(D26-F26,30),"0"). I also tried =IF(SUM(D26-F26)
5,MIN(D26-F26,30),"0"). But I keep getting "0", unless I enter a
number higher than "10", which is confusing, as the quantative value
here is 5.

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
formula to work in a 3-d reference with 2 work books	capt c	Excel Worksheet Functions	1	April 8th 09 08:04 PM
Sorting the cells of a formula causes the formula to not work	Jake	Excel Worksheet Functions	3	January 31st 09 04:42 AM
IF-then formula doesn't work	pegman	Excel Discussion (Misc queries)	6	January 5th 08 06:55 PM
The same formula doesn't work again?	Hru48	Excel Worksheet Functions	1	June 19th 06 08:18 PM
A search for $ in a formula use to work now it does not work	JuneJuly	Excel Discussion (Misc queries)	2	November 30th 05 10:13 PM

All times are GMT +1. The time now is 02:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us