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 conditional formatting based on date - Guide
- How to clear formatting in excel - Guide
- Formatting windows 7 - Guide
- Hp formatting tool - Download - Storage
- Formatting sd card to fat32 - 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!
