Conditional formatting
Closed
RV061257
Posts
1
Registration date
Wednesday August 19, 2015
Status
Member
Last seen
August 19, 2015
-
Aug 19, 2015 at 07:36 PM
Blocked Profile - Aug 19, 2015 at 08:23 PM
Blocked Profile - Aug 19, 2015 at 08:23 PM
Related:
- Conditional formatting
- Excel formula to change cell color without conditional formatting - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
- How to clear formatting in excel - Guide
1 response
IN cell C1, place the following (this would be known as a Nested If):
=IF(A1="Pos",IF(B1="Single","$538.00",""),"")
Give that a try. The format of if is as follows: =If(logic statement,true, false).
In this example, we have another test if True, before we can make a true.
Have Fun!
I have said it once, I will say it again. IT!
=IF(A1="Pos",IF(B1="Single","$538.00",""),"")
Give that a try. The format of if is as follows: =If(logic statement,true, false).
In this example, we have another test if True, before we can make a true.
Have Fun!
I have said it once, I will say it again. IT!
