Cell Formula
 

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?


--
dcchica
------------------------------------------------------------------------
dcchica's Profile: http://www.excelforum.com/member.php...o&userid=30601
View this thread: http://www.excelforum.com/showthread...hreadid=502532

Cell Formula
 

In the first column type the formula:-

=If(C1<6,C1,0)

and in the next column

=if(C16,C1,0)

Assuming the totals are in column C


--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=502532

Cell Formula
 

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?


--
dcchica
------------------------------------------------------------------------
dcchica's Profile: http://www.excelforum.com/member.php...o&userid=30601
View this thread: http://www.excelforum.com/showthread...hreadid=502532