Romano_odK
Active Member
- Joined
- Jun 4, 2020
- Messages
- 379
- Office Version
- 365
- Platform
- Windows
Good afternoon,
In this formula below I would like to add the following. When M8 = empty place the value from from N8 in this cell. The cell where this formula is in is L8. The simple thing here is that I can't figure out what I how I can refer "empty". I tried several things like "", but that doesn't work.
Thank you for your time.
Romano
In this formula below I would like to add the following. When M8 = empty place the value from from N8 in this cell. The cell where this formula is in is L8. The simple thing here is that I can't figure out what I how I can refer "empty". I tried several things like "", but that doesn't work.
Excel Formula:
=IFERROR(ROUND(IFS(M8>0;N8*M8+N8);2);"")
Thank you for your time.
Romano