Help in < or mathematical excel equations
 

Bear in mind that by putting your 0.20 and 0.40 in quotes you are outputting
a text string, not a number.
--
David Biddulph

"polardude1983" wrote in message
...


"polardude1983" wrote:

basically what i want to do is if Cell number H2 is greater then 0.01 and
less then 0.99 then H2 equals 0.20

but if H2 is greater then 1.00 and less then 9.99 then H2 equals 0.40
can anybody help me with this? i have this so far

=IF(AND(H2<0.99,H20.01),"0.20","Invalid")

I GOT IT here is for some people who might want to know

=IF(AND(H2<=0.99,H2=0.01),"0.20",IF(AND(H2<=9.99, H2=1),"0.40","INVALID"))