Thread: Problem with adding "+1" to one cell while another cell decreased by "1"?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Problem with adding "+1" to one cell while another cell decreased by "1"?
Too simple and elegant for me<g

Gord

On Fri, 27 Jul 2007 17:39:07 +0100, "Roger Govier"
wrote:

Hi Michael

With your total in A1
=MAX(0,6-A1)

Reply With QuoteReply With Quote