Thread: if function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
 
Posts: 1,522
Default if function

On Tuesday, October 30, 2012 12:29:23 PM UTC-5, Duncan Robert wrote:
I'm fairly new to excel. I have a problem with a formula that I need

help on. Here is what I want to do.



If B2 is between 270 and 284 then return .013 in C2

If B2 is between 285 and 290 then return .135 in C2



I have more senereos for the same formula, but I'm sure you get the

idea.



Any help would be appreciated!



Duncan Robert









--

Duncan Robert


Have a look at the help index for CHOOSE