Thread: If statement
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Zack Zack is offline
external usenet poster
 
Posts: 17
Default If statement

In cell H4 I want one of three model numbers to appear. Each model number is
assigned a value, so 1112111 will equal HRV019SB1. So the formula for H4 is,
as of now, =IF(H4=1112111,"HRV019SB1"). And that works great if 1112111
appears. How do I write the formula for multiple values, so if 2112111
appears, a different model number will be shown.

Here's my example
1112111=HRV019SB1
2112111=HRH019SB1
1113111=HRV024SB1