View Single Post
  #1   Report Post  
Nathan McElmurry
 
Posts: n/a
Default multiple IF statements

i can't seem to write a formula that does the following:

if cell C3 = 1X1, return 725 as the value; if cell C3 = 1X2, return 872 as
the value; if cell C3 = 2X2, return 1003 as the value; if cell C# = 3X2,
return 1156 as the value.

any suggestions?