Posted to microsoft.public.excel.programming

Simon Lloyd[_636_] Simon Lloyd[_636_] is offline

external usenet poster

Posts: 1

Nested if statement problem!

All sorted now thanks to Toppers!

=COUNTIF(Hols1,"Bloggs J")*8+COUNTIF(Hols2,"Bloggs J")*1

--
Simon Lloy
-----------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...nfo&userid=670
View this thread: http://www.excelforum.com/showthread.php?threadid=39090

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
Nested IF statement	WIJ	Excel Discussion (Misc queries)	3	October 27th 09 05:39 AM
Nested if statement ?	Angelaf	Excel Worksheet Functions	3	April 14th 08 02:28 PM
NESTED IF STATEMENT	jmsbert	Excel Worksheet Functions	10	October 10th 05 04:25 PM
Problem with nested IF_OR statement	DOOGIE	Excel Worksheet Functions	7	June 24th 05 03:27 AM
7+ nested if statement?	Turi	Excel Worksheet Functions	3	December 20th 04 07:55 PM

All times are GMT +1. The time now is 11:24 AM.

About Us

"It's about Microsoft Excel"