Thread: if the value of a cell is between 2 values
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Harish B Harish B is offline
external usenet poster
  
Posts: 2
Default if the value of a cell is between 2 values
I want to set value of a cell (h2) to 30 if the value of other cell (d2) is
between 2000 & 5000.
and to 60 if between 5000 & 10000 by using formula.

how can i do this.
--
Harish B.
Reply With QuoteReply With Quote