ExcelBanter - If Function ignoring rest of formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - If Function ignoring rest of formula (https://www.excelbanter.com/excel-programming/413014-if-function-ignoring-rest-formula.html)

Hamed parhizkar

If Function ignoring rest of formula

I have a formula, it reads"

=A9&"\r"&B9*100&"\r"&C9&"\r"&D9&"\r"&F9&"\r"&G9*-100&"\r"&H9

The formula is being copied into a data entry system that converts the info
into different columns.

The problem is if C9= 0 then I need the "\r" to not be there and continue on
with the rest of the formula.

Is there anything I can do?

Ken Johnson

If Function ignoring rest of formula

On Jun 24, 7:19 am, Hamed parhizkar
wrote:
I have a formula, it reads"

=A9&"\r"&B9*100&"\r"&C9&"\r"&D9&"\r"&F9&"\r"&G9*-100&"\r"&H9

The formula is being copied into a data entry system that converts the info
into different columns.

The problem is if C9= 0 then I need the "\r" to not be there and continue on
with the rest of the formula.

Is there anything I can do?

=A9&"\r"&B9*100&"\r"&IF(C9<0,C9
&"\r","")&D9&"\r"&F9&"\r"&G9*-100&"\r"&H9

Ken Johnson

All times are GMT +1. The time now is 12:40 PM.