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 |
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 |