Thread: putting a number that is greater or lesser into different cell .
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James Krepel James Krepel is offline
external usenet poster
  
Posts: 1
Default putting a number that is greater or lesser into different cell .
I need a way to be able to take a number say 30 as a base so that any number
30 or less is put in a cell but if it is larger than 30 then 30 is put into
that cell and everything over is put into another cell
Reply With QuoteReply With Quote