How can I act on an empty cell.

[Romano_odK]

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.

=IFERROR(ROUND(IFS(M8>0;N8*M8+N8);2);"")

Thank you for your time.

Romano

 

[Fluff]

How about

=IF(M8="";"";IFERROR(ROUND(IF(M8>0;N8*M8+N8;0);2);""))

 

[Romano_odK]

How about

=IF(M8="";"";IFERROR(ROUND(IF(M8>0;N8*M8+N8;0);2);""))

This is exactly what I was looking for. So a different approach with IF and not IFS. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.