software

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: www.excelforum.com/member.php...oamp;userid=30601
View this thread: www.excelforum.com/showthread...hreadid=502532
In the first column type the formula:-

=If(C1lt;6,C1,0)

and in the next column

=if(C1gt;6,C1,0)

Assuming the totals are in column C--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: www.excelforum.com/member.php...oamp;userid=17084
View this thread: www.excelforum.com/showthread...hreadid=502532
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: www.excelforum.com/member.php...oamp;userid=30601
View this thread: www.excelforum.com/showthread...hreadid=502532