Thread: if function
View Single Post
  #1   Report Post  
Duncan Robert Duncan Robert is offline
Junior Member
 
Posts: 1
Post if function

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