Posted to microsoft.public.excel.misc

Mandeep Baluja Mandeep Baluja is offline

external usenet poster

Posts: 25

Guidance Required #01

=IF(A1<=TIME(12,0,0),"Morning Report",IF(A1<=TIME(13,0,0),"Afternoon Report","Evening Report"))

check this out !!!

1) in starting you have written if Cell A1 is equaly or between 12:00PM to 17:59 PM then CELL B1 should display Afternoon Report
2) Then you wrote Afternoon Status is only between 12:00hr till 13:00hrs.

Please stick to one parameter only

Regards,
mandeep baluja

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
In need of more guidance please....	Vacuum Sealed	Excel Programming	10	June 21st 11 11:48 AM
Guidance required please...	Vacuum Sealed	Excel Programming	19	June 20th 11 11:32 AM
Guidance, please (xl2007)	Kragelund	Excel Programming	5	December 8th 08 08:28 PM
Need some guidance	Buxton	Excel Worksheet Functions	1	December 25th 07 09:11 PM
Architectural guidance, please	Mike	Excel Discussion (Misc queries)	0	April 26th 05 09:16 PM

All times are GMT +1. The time now is 10:37 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us