Thread: Formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KJB61
 
Posts: n/a
Default Formulas

I am trying to create a formula where cell A is one number and I was cell b
to be 2 times that amount but not higher then X so say Cell a has 125000
so cell B would be 250000 if it was 2 times the number, but if the highest
number is 200000 how would I do that?