IF FUNCTION - ExcelBanter

Posted to microsoft.public.excel.programming

external usenet poster

Posts: 4

IF FUNCTION

hi

Please could someone advise what is wrong with this formula:

=IF(B26<=0,"0%",IF(B26=1<=4,"5%",IF(B26<=4,"5%",I F(B26=5<=14,"25%",IF(B26<=14,"25%",IF(B26=15<=24 ,"50%",IF(B26<=24,"50%",IF(B26=25,"75%"))))))) )

The problem is if B26<0 it works...but if B26=0 it evaluates to 5% not
to 0% as it should according to the formula.

Thanks
Vasen

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
Excel Data Validation/Lookup function does function correcty	Kirkey	Excel Worksheet Functions	2	May 25th 09 09:22 PM
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook)	[email protected]	Excel Worksheet Functions	0	September 5th 06 03:44 PM
Offset function with nested match function not finding host ss.	MKunert	Excel Worksheet Functions	1	March 21st 06 10:46 PM
Adding a custom function to the default excel function list	DonutDel	Excel Programming	3	November 21st 03 03:41 PM
User-Defined Function pre-empting Built-in Function? How to undo????	MarWun	Excel Programming	1	August 6th 03 09:31 PM

All times are GMT +1. The time now is 06:07 AM.

Menu

About Us