If and value between two numbers
 

Hi everyone,

Could someone help me with the following formula please?

Cell M1 contains formula =IF(A1<J12,(A1*100)," ")

What I need is if A1 is less than J12 then A1(*100) should show in the cell
but then

Cell M2 contains formula =IF(OR(A1=J12,A1<G12),a1*100," ")

If A1 is greater than or equal to J12 but less than G12 then A1(*100) should
show in the cell

Hope this makes sense €“ it is Friday afternoon here and brain cells are
firing extremely slowly ;-))

TIA

--
Mifty

If and value between two numbers
 

Cell M2 contains formula =IF(OR(A1=J12,A1<G12),a1*100," ")
Replace the formula in M2 with this:
=IF(AND(A1=J12,A1<G12),A1*100,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mifty" wrote:
Hi everyone,

Could someone help me with the following formula please?

Cell M1 contains formula =IF(A1<J12,(A1*100)," ")

What I need is if A1 is less than J12 then A1(*100) should show in the cell
but then

Cell M2 contains formula =IF(OR(A1=J12,A1<G12),a1*100," ")

If A1 is greater than or equal to J12 but less than G12 then A1(*100) should
show in the cell

Hope this makes sense €“ it is Friday afternoon here and brain cells are
firing extremely slowly ;-))

TIA

--
Mifty

If and value between two numbers
 

Happy me :-)

That did the trick

Many many thanks
--
Mifty


"Max" wrote:

Cell M2 contains formula =IF(OR(A1=J12,A1<G12),a1*100," ")
Replace the formula in M2 with this:
=IF(AND(A1=J12,A1<G12),A1*100,"")
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mifty" wrote:
Hi everyone,

Could someone help me with the following formula please?

Cell M1 contains formula =IF(A1<J12,(A1*100)," ")

What I need is if A1 is less than J12 then A1(*100) should show in the cell
but then

Cell M2 contains formula =IF(OR(A1=J12,A1<G12),a1*100," ")

If A1 is greater than or equal to J12 but less than G12 then A1(*100) should
show in the cell

Hope this makes sense €“ it is Friday afternoon here and brain cells are
firing extremely slowly ;-))

TIA

--
Mifty

If and value between two numbers
 

welcome, glad it helped
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mifty" wrote in message
...
Happy me :-)

That did the trick

Many many thanks
--
Mifty