Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
expanding custom formatting without removing existing cell formatting? | Excel Worksheet Functions |