Conditional formatting

Registration date
Wednesday August 19, 2015
Last seen
August 19, 2015
 Blocked Profile -

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):

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!