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 |
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 |
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 |
All times are GMT +1. The time now is 10:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com