| 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?? :( |
| 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)
Threaded Mode
