formatting
 

i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3

Can anyone help please

formatting
 

On Nov 17, 12:43*pm, Chris wrote:
i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3

Can anyone help please

Chris, your query is not very clear but in case you mean conditional
formatting, then just select the range of cells you want to be
formatted, and go to FORMAT CONDITIONAL FORMATTING there you will
find a wizard :
cell value | is between | (here you put "0") | (here you put "100")|
then press format and format the cell as you please, when you are done
with the first condition, click on "Add" and do the same for the
condition where cell is between 101 and 200 with another pattern i
suppose.

formatting
 

if you mean by format a formula that will be placed in B:B
then just put the following in B2
=IF((A2<200)*(A2100),A2*3,IF(A2<100,A2*2))
in case the value of your cell is < 0 or 200, you will need to alter
the "false" value of the if statement

formatting
 

try this

=IF(AND(A2=0,A2<=100),A2*2,IF(AND(A2100,A2<=200) ,A2*3,""))


On Nov 17, 3:43*pm, Chris wrote:
i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3

Can anyone help please

formatting
 

I don't want to colour the cell or change the font i want to multiply the
figure by 2 if it is between 0 and 100

"Totti" wrote:

On Nov 17, 12:43 pm, Chris wrote:
i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3

Can anyone help please

Chris, your query is not very clear but in case you mean conditional
formatting, then just select the range of cells you want to be
formatted, and go to FORMAT CONDITIONAL FORMATTING there you will
find a wizard :
cell value | is between | (here you put "0") | (here you put "100")|
then press format and format the cell as you please, when you are done
with the first condition, click on "Add" and do the same for the
condition where cell is between 101 and 200 with another pattern i
suppose.

formatting
 

THANK YOU :-)

"muddan madhu" wrote:

try this

=IF(AND(A2=0,A2<=100),A2*2,IF(AND(A2100,A2<=200) ,A2*3,""))


On Nov 17, 3:43 pm, Chris wrote:
i am trying to put a format in excel of
if box A2 is between 0-100 then *2 or if it's between 101-200 then *3

Can anyone help please