-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
slightly
-
H
AND & OR Together?
hi I am trying to get a particular result, but I have obviously got the syntax slightly wrong in my formula and I wonder if someone might look at it and indicate where I went wrong. Here is the formula:- =IF(AND(Q2="L",P2<=2.2,OR(Q2="P",P2<=2.2)),95,IF(AND(Q2="W",P2<=2.2),-100*P2+100,0)) In...- honkin
- Thread
- and & or statement formula formula- slightly wrong
- Replies: 3
- Forum: Excel Questions
-
M
Conditional Formating based on # of cells with certain color.
Hi, I have this conditional formatting rule: =AND($W2<>0,$W2<>"") It is applying a light green fill color when the conditions are met. What I would like to do is have every group of 14 rows alternate between this color and a slightly different color. Is it possible to setup another...- Mlogs
- Thread
- color conditional formatting rule slightly
- Replies: 6
- Forum: Excel Questions
-
R
Nested If Function
I have a 2 column table with a list of items, each getting a score from 0 to 1. I'm trying to create a third column that will generate one of 7 dfferent text values, each corresponding to a range of possible scores. Here's the formula I have: =IF(I2>0.8,"Far Right",IF(I2>0.7,"Center...- rationaloptimism
- Thread
- column formula slightly values working
- Replies: 5
- Forum: Excel Questions
