Thread: Posible IF formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Hanah Hanah is offline
external usenet poster
  
Posts: 6
Default Posible IF formula
A2 can have 3 kind of values. Eg. 1000, 2000, or 3000. If A2 is 1000, B2 is
140, if A2 is 2000, B2 is 14, if A2 is 3000, B2 is 177. Please help, how can
I write a formula for this.
Reply With QuoteReply With Quote