| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF formula help part two
I am trying to do a similar thing but my values are different.
The idea is that if J16 equals 0, then G11 will show 0 If J16 is greater than 0 and less than 1, then G11 will show 0 If J16 is equal to 1 but less than 2, then G11 will show 1.5 If J16 is equal to 2 but less than 3, then G11 will show 1.75 If J16 is equal to 3 but less than 4, then G11 will show 2 If J16 is equal to 4 but less than 5, then G11 will show 2.5 Can someone help me with this one?? :( |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula help part two
On Tue, 12 Feb 2008 08:48:02 -0800, IF function incompetent
wrote: I am trying to do a similar thing but my values are different. The idea is that if J16 equals 0, then G11 will show 0 If J16 is greater than 0 and less than 1, then G11 will show 0 If J16 is equal to 1 but less than 2, then G11 will show 1.5 If J16 is equal to 2 but less than 3, then G11 will show 1.75 If J16 is equal to 3 but less than 4, then G11 will show 2 If J16 is equal to 4 but less than 5, then G11 will show 2.5 Can someone help me with this one?? :( IT will be easier to use VLOOKUP. Then you can set your values/equivalences to whatever you want. --ron |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
IF formula help part two
possibly
=IF(J16<0,"",CHOOSE(MIN(J16+1,6),0,1.5,1.7,2,2.5," ")) Mike "IF function incompetent" wrote: I am trying to do a similar thing but my values are different. The idea is that if J16 equals 0, then G11 will show 0 If J16 is greater than 0 and less than 1, then G11 will show 0 If J16 is equal to 1 but less than 2, then G11 will show 1.5 If J16 is equal to 2 but less than 3, then G11 will show 1.75 If J16 is equal to 3 but less than 4, then G11 will show 2 If J16 is equal to 4 but less than 5, then G11 will show 2.5 Can someone help me with this one?? :( |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change color of all cells with formula or are part of a formula | Excel Discussion (Misc queries) | |||
| 2 Part Formula | Excel Worksheet Functions | |||
| Looking for formula part 2 | Excel Discussion (Misc queries) | |||
| Add one part of a formula to another | Excel Discussion (Misc queries) | |||
| Delete part of a formula | Excel Discussion (Misc queries) | |||
![IF function incompetent[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
