Conditional formatting

[Closed]
Report
Posts
1
Registration date
Wednesday August 19, 2015
Status
Member
Last seen
August 19, 2015
-
 Blocked Profile -
Hello,

I'm trying to write a conditional format formula populating one cell (column of cells) based on the text content of cells in 2 other columns. Example: If cell A1 reads (POS), and cell B1 reads (Single), I want cell C1 to populate with the text $538.50. Is this possible? If formatting doesn't work would a pivot table?

1 reply


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!