Thread: how do I set up a formula using number ranges as the arguments
View Single Post
  #1   Report Post  
Ballykea
 
Posts: n/a
Default how do I set up a formula using number ranges as the arguments
If cell figure is less than 287 use a.
if cell figure is between 287.01 & 400 use b
if cell figure is over 400.01 use c.
where a, b, & c are formula, should I be looking at Lookup table?
Reply With QuoteReply With Quote