Thread: Formula How
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
John Nicho John Nicho is offline
external usenet poster
 
Posts: 1
Default Formula How

Hi,
I'm stuck,
How do I create a Formula for this please:
highlight C5 referencing C1 & if C1 = less than 1 = 0 & if 1 - 10000 =10
Thanks,
John