Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm running out of ideas for the following situation:
If Cell.Value 0 and Cell.Value <=0.2 then (code) Else If Cell.Value 0.2 and Cell.Value <=.4 (other code) Else If Cell.Value 0.4 and Cell.Value <=.6 (other code) Else If Cell.Value 0.6 and Cell.Value <=.8 (other code) Else Cell.Value 0.8 and Cell.Value <=1 (other code) End If Is there an easier way to do this? Am I missing something obvious? Right now, I can't figure out how to make this scheme work. Any pointers you can give me will be gratefully received. Thanks, MJohn |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Cell Formatting of a Conditional Statement | Excel Worksheet Functions | |||
conditional statement using validation cell | Excel Worksheet Functions | |||
Need conditional statement to paint a cell | Excel Discussion (Misc queries) | |||
Need conditional statement to paint a cell | Excel Worksheet Functions | |||
formating a cell with a conditional if statement | Excel Programming |