Gus

Posts: n/a

example if IF(ISNA()) function

Hi

Please could someone assist. I have a formular: =IF((E34="Not
Done"),NOW()-C34,"") which works but I am trying to return a "" value when
"Not done" is not displayed. I have tried using
=IF(isna((E35="Not Done"),NOW()-C35,""),"",((E35="Not Done"),NOW()-C35,""))
but this is not working.
Thks
Gus

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
Averaging function	Sarah	Excel Discussion (Misc queries)	0	January 18th 05 04:09 PM
I cant use englisch function names in a swedich version of excel	PE	Excel Discussion (Misc queries)	2	December 7th 04 01:00 AM
change function variable prompts??	thinkingfield	Excel Worksheet Functions	1	November 8th 04 04:01 PM
Counting Function Dilemma	Simon Lloyd	Excel Worksheet Functions	0	November 8th 04 03:13 PM
need to save values from a function before it changes	Ron	Excel Worksheet Functions	1	October 29th 04 06:29 AM

All times are GMT +1. The time now is 01:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us