Query on Logical Values

**kamalthakur** · 01-13-2010, 09:06 AM

Hi,

I have a simple query

I have to enter values between two percentages like

If value is between 25% to 50% then it should calculate 0.5*.15*15% and If value is greater than 50% then it should calculate as 1*.15*15%

I want this as one function

**martindwilson** · 01-13-2010, 09:10 AM

=if(and(a1>=0.25,<=0.5),0.5*.15*15% ,if(a1>0.5,1*.15*15%,a1)

i cant really read these

0.5*.15*15% 1*.15*15%

**lian.cragg** · 01-13-2010, 09:15 AM

=IF(AND(A1>25,A1<50),0.5*0.15/100*15,IF(A1>50,1*0.15/100*15,"less than 25"))

**martindwilson** · 01-13-2010, 09:18 AM

lian <50 wont work you'd need <50% but it does depend on wether op has actually used % in cell!

**lian.cragg** · 01-13-2010, 09:27 AM

Hi Martin, if you use it without the percentage it works fine, otherwise just change it to

=IF(AND(A1>25%,A1<50%),0.5*0.15/100*15,IF(A1>50%,1*0.15/100*15,"less than 25"))

**kamalthakur** · 01-13-2010, 09:28 AM

It is not working

Lets say A1 has Value 15% B1 has 0.15

My condition is if I enter value between 25% to 50% in C1 then It should calcuate the value as 0.5*B1*c1

And same as if the value which i enter in C1 is greater than 50% then it calculate as 1*b1*a1

and if the value is below 25% then it should be 0

**martindwilson** · 01-13-2010, 09:31 AM

lian it wont work! if you format a cell as % and type in 50 it displays 50% but the underlying value is 0.5
thats what you have to test against. that why you either use 0.5 or 50% instead of just 50
kamalthakur
whats in the actual cells how are they formated, post a worksheet