| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with conditional formula for greater/less than
I could use some help in constructing an IF formula that is based on
greater/less than. I have a COUNTA formula for a column of data. Based on that result, I want to point to a different cell depending on the result of the count. For example, if the result is 0 or 1, I want to point to B21. If the result is between 2-5, I want to point to B22. Any help would be greatly appreciated! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with conditional formula for greater/less than
=if(counta(D1..D100)<3,B21,B22)
"charlie" wrote: I could use some help in constructing an IF formula that is based on greater/less than. I have a COUNTA formula for a column of data. Based on that result, I want to point to a different cell depending on the result of the count. For example, if the result is 0 or 1, I want to point to B21. If the result is between 2-5, I want to point to B22. Any help would be greatly appreciated! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with conditional formula for greater/less than
Sorry, I should have expanded a little. I have more than just the two
ranges that I need to reference (it's not just a simple either/or result). For example, the next range result would be 6-10. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Help with conditional formula for greater/less than
If you have more than a few ranges, I'd suggest using a vlookup.
"charlie" wrote: Sorry, I should have expanded a little. I have more than just the two ranges that I need to reference (it's not just a simple either/or result). For example, the next range result would be 6-10. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formating greater than | Excel Discussion (Misc queries) | |||
| Conditional Formating if Greater Than or Less Than other column | Excel Worksheet Functions | |||
| colors and conditional format - greater than, less than | Excel Discussion (Misc queries) | |||
| Conditional printing based on cells greater than zero | Excel Worksheet Functions | |||
| conditional format greater or less than | Excel Discussion (Misc queries) | |||
Linear Mode
