IF function
 

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,

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,

IF function
 

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

One way:

=IF(A1="","",IF(A10.5,"High",IF(A1=0.25,"Medium" ,"Low")))

--
Biff
Microsoft Excel MVP


"Suri" wrote in message
...

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,

IF function
 

Many thanks. It worked..
"FSt1" wrote:

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,