Posted to microsoft.public.excel.worksheet.functions

Harry S[_2_] Harry S[_2_] is offline

external usenet poster

Posts: 1

Multiple IF functions

I like to enter a multiple IF funcution formula that looks like this:
=if(a10<5,x1+1,if(a105<10,x1+2,if(a1010<20,x1+3) ))
Always getting an FALSE message what am I doing wrong?

--
Harry S

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
Multiple functions, conditional functions	HeatherBelle	Excel Worksheet Functions	7	October 17th 08 03:57 PM
Index & Match functions - multiple criteria and multiple results	[email protected]	Excel Worksheet Functions	4	May 2nd 07 03:13 AM
Multiple IF functions	mpenkala	Excel Worksheet Functions	2	April 24th 07 09:10 PM
How do I use multiple functions?	Dan L.	Excel Worksheet Functions	3	December 13th 05 10:09 AM
Multiple IF functions	questionsforms	Excel Worksheet Functions	2	October 30th 05 03:12 AM

All times are GMT +1. The time now is 05:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us