Posted to microsoft.public.excel.worksheet.functions

baz

Posts: n/a

Why doesn't this work "=IF(C2= "13:00",C2+"16:00",C2+"4:00")

in this configuration the "=" gives the opposite answer, other operators
also give wrong answers.

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
Work Rota - Do I need a formula?	dataheadache	Excel Discussion (Misc queries)	11	October 3rd 05 10:53 PM
Work book formulas	Jessica	Excel Discussion (Misc queries)	1	June 9th 05 10:51 AM

All times are GMT +1. The time now is 06:55 PM.

About Us

"It's about Microsoft Excel"