Resubmitting a question from yesterday...formula

Posted to microsoft.public.excel.programming

Casey[_14_] Casey[_14_] is offline

external usenet poster

Posts: 1

Resubmitting a question from yesterday...formula

Peter,
Try
=IF(C1=0,"all stores",IF(AND(C1<0,C16),"",C1))

Hope this helps

Case

--
Message posted from http://www.ExcelForum.com

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to 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
How do I find a question I posted yesterday?	englishrose4719	Excel Discussion (Misc queries)	5	October 21st 09 02:05 PM
where can I see my question and answer? Yesterday I ask a question	IP	Excel Discussion (Misc queries)	2	May 10th 08 04:08 PM
need second answer to question posted yesterday (niek Otten)	jimE	Excel Worksheet Functions	3	October 24th 07 01:21 AM
Please can someone look at question i posted yesterday	jimE	Excel Worksheet Functions	2	October 23rd 07 10:27 PM
I really need help. Need a formula. Need it yesterday.	Dennis	New Users to Excel	1	March 12th 07 08:53 PM

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

About Us