Thread: Formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Formula help

=IF(E3=1,299),IF(E3=2,149),IF(E3=3,100),IF(E3=5,59 ,0))

This is what i need, E3=1.00 then return the value of 299
E3=2.00 then return the value of 149
E3=3.00 then return the value of 99
E3=5.00 then return the value of 59