Thread: cell formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TechyTemp TechyTemp is offline
external usenet poster
 
Posts: 5
Default cell formulas

I'm working on two columns of percentages - cost and profit. Occassionally,
the numbers are weird and so the percentages are either negative or extremely
large. What kind of code can I write so that, if the numbers are not within
a certain range,a default number is entered?