Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Im trying to set up a spreadsheet that will indicate whether or not multiple
values are acceptable or rejectable for percentages entered for a single line. For example.... Percentages entered into A3, B3, and C3 needs to be between 3.0 and 5.0..... if the percentage entered is 2.9 or below / 5.1 or above in any cell, it will automatically fill in E3 with an "X". And if any percentage entered is between 3.0 and 5.0 it will fill in D3 with an "X". Something like this. (as best as I could describe it) A B C D E 1 Element 1 Element2 Element3 2 3.0 - 5.0 3.0 - 5.0 3.0 - 5.0 A R 3 2.8 4.5 4.9 X 4 3.5 4.1 3.9 X I was able to accomplish this a long time ago, however it was several years ago and I dont have the first clue as to how I managed to accomplish it before. Can anyone please help????? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Format cell to accept only specific character-reject others | Excel Discussion (Misc queries) | |||
In a shared workbook, can only one person "accept or reject" chang | Excel Discussion (Misc queries) | |||
can only one person accept or reject changes in a shared workbook? | Excel Discussion (Misc queries) | |||
Disable Accept/Reject Changes | Excel Discussion (Misc queries) | |||
Formula to calucate # of months based on a speificed date entered | Excel Worksheet Functions |