| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF FUNCTION
Hi Vasen!
It's working OK for me, although I can't see why you're not using VLOOKUP. Also, you haven't covered empty cell or text inputs to B26 -- Regards Norman Harker MVP (Excel) Sydney, Australia Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "vee" wrote in message om... 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%",I F(B26<=14,"25%",IF(B26=15<=24,"50%",IF(B26<=24,"5 0%",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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
| LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
| User-Defined Function pre-empting Built-in Function? How to undo???? | Excel Programming | |||
Hybrid Mode
