Thread: IF function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default IF function

hi
try this.....
=IF(A1<0.25,"Low",IF(A10.5,"High","Medium"))

regards
FSt1


"Suri" wrote:


HI,

I want to write a formula as below.

Ex. Cel A1 = if cel A1 <.25 = Low
if cel A1 is between .25-.5 = Medium

if cel A1 is .5 = High

Can spmeone kindly let me know how to have all in 1.

Many Thanks,