Thread: Posible IF formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
M Kan M Kan is offline
external usenet poster
  
Posts: 169
Default Posible IF formula
I think this is the formula in B2

=IF(A2=1000,140,IF(A2=2000,14,117))
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Hanah" wrote:

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