View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eclaires Eclaires is offline
external usenet poster
 
Posts: 10
Default CALCULATION BASED ON MORE THAN TWO CONDITIONS

Please would someone help me again?

I need to come up with a value in one cell dependent on conditions being met
or not met in another.

eg: if value in A1 is zero return value in A2 as zero, but if value in A1 is
greater than zero but less than 240 return a value of 240, however if value
in A1 is over 240 return whatever value it is in A2.

Hope this makes sense.

Kind regards


Eclaires