| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
multiple if
Range from to Low Upper 1 0 50 5% 95% 2 51 100 10% 90% 3 101 999999 20% 70% If 0 =< 50 then 1 If = 51 < = 100 then 2 if 100 then 3 I struggling wit a if function and this is what I want, assistanc appreciated thanks Thie -- Thie ----------------------------------------------------------------------- Thiem's Profile: http://www.excelforum.com/member.php...fo&userid=2747 View this thread: http://www.excelforum.com/showthread.php?threadid=52814 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple if
=IF(A1<=0,0,IF(A1<=50,1,IF(A1<=100,2,3)))
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Thiem" wrote in message ... Range from to Low Upper 1 0 50 5% 95% 2 51 100 10% 90% 3 101 999999 20% 70% If 0 =< 50 then 1 If = 51 < = 100 then 2 if 100 then 3 I struggling wit a if function and this is what I want, assistance appreciated thanks Thiem -- Thiem ------------------------------------------------------------------------ Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474 View this thread: http://www.excelforum.com/showthread...hreadid=528147 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple if
Sorry Bob Not Working -- Thiem ------------------------------------------------------------------------ Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474 View this thread: http://www.excelforum.com/showthread...hreadid=528147 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
multiple if
In what way?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "Thiem" wrote in message ... Sorry Bob Not Working -- Thiem ------------------------------------------------------------------------ Thiem's Profile: http://www.excelforum.com/member.php...o&userid=27474 View this thread: http://www.excelforum.com/showthread...hreadid=528147 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete Blank Rows Code - Multiple Worksheets - Multiple Documents | Excel Discussion (Misc queries) | |||
| Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails | Excel Programming | |||
| Creating Multiple GIFs from Multiple Range selections -- I need a volunteer to test my code to see why it fails | Excel Programming | |||
| Crteating Multiple GIFS from Multiple Ranges -- need someone to test my code to see why it fails | Excel Programming | |||
| view multiple files in multiple windows on multiple screens. | Excel Discussion (Misc queries) | |||
![Thiem[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
