Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If statement using multi columns
I'm in column H and I first want to check the value in column A to determine
if it is over or under 80% Example: If the value in column A is 80% or greater, I don't want anything to show up in column H. If the value in column A is less than 80% AND column B is <= 1%, show ".5%" in column H. If the value in column A is less than 80% AND column B is between 1.1% and 2%, show "1%" in column H. If the value in column A is less than 80% AND column B is between 2.1% and 3%, show "2%" in column H. If the value in column A is less than 80% AND column B is = 3.1%, show "3%" in column H. Can someone help me with this one? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to swap rows and columns? | Excel Discussion (Misc queries) | |||
Help with grouping columns | New Users to Excel | |||
Hiding columns and custom views problem | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |