| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cell formular
I am trying to write a formular in a cell whereby if the value of an ajoining
cell is between 2 and 5, then enter 50. If the value is not between 2 and 5 then enter zero. I have not found the proper formular so far, can someone assist me? Thanks. -- rshfl |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell formular
Something like the following:
=IF(AND(A22,A2<5),50,0) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Ron H" wrote: I am trying to write a formular in a cell whereby if the value of an ajoining cell is between 2 and 5, then enter 50. If the value is not between 2 and 5 then enter zero. I have not found the proper formular so far, can someone assist me? Thanks. -- rshfl |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cell formular
=IF(AND(A1=2,A1<=5),50,0)
will include the numbers 2 and 5. "Ron H" wrote in message ... I am trying to write a formular in a cell whereby if the value of an ajoining cell is between 2 and 5, then enter 50. If the value is not between 2 and 5 then enter zero. I have not found the proper formular so far, can someone assist me? Thanks. -- rshfl |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell formular | Excel Discussion (Misc queries) | |||
| cell formular | Excel Discussion (Misc queries) | |||
| Cell formular | Excel Discussion (Misc queries) | |||
| can I lock just the formular in a cell | Excel Worksheet Functions | |||
| How can we formular a dynamic cell? i.e. =B2 as ="B"&"2"?? | Excel Worksheet Functions | |||
Linear Mode
