Thread: Cell Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dcchica
 
Posts: n/a
Default 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