IF function

[Suri]

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,

 

[FSt1]

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

regards
FSt1

 

[T. Valko]

Assuming A1 will only contain a number (or maybe be empty/blank)

One way:

=IF(A1="","",IF(A1>0.5,"High",IF(A1>=0.25,"Medium","Low")))

 

[Suri]

Many thanks. It worked..

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

regards
FSt1