Cell Formula

D

dcchica

I have a spreadsheet with several columns of numbers. These numbers are
totaled in one column. I would like the column next to it to show the
amount less than 6 and the column next to that to show the amount
greater than 6. How do I format the cell to do that?
 
G

Gary Brown

In the first column type the formula:-

=If(C1<6,C1,0)

and in the next column

=if(C1>6,C1,0)

Assuming the totals are in column C
 
D

dcchica

The first formula worked. But when I used the second formula, I got
6.25 not just .25. Is there a way so that it can show just .25?
 
Top