Help with "IF" function
Hi everyone. I am new and need help. I am clueless with functions. I am trying to write a "IF" function that says........
If R2 equals 000000, NONOUT, or OUT......then it is O&M. If not equal 000000, NONOUT, or OUT......then it is capital. I tried this formula but it does not work: =IF(R20,"capital","O&M") I know it is more to it. Please help and thanks in advance. |
Quote:
The above would work if the 000000 is actually a number, if it's text then change it to =IF(OR(R2="000000",R2="NONOUT",R2="OUT"),"O&M","CA PITAL") |
Quote:
|
Quote:
|
All times are GMT +1. The time now is 12:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com