If Function ignoring rest of formula

H

Hamed parhizkar

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?
 
K

Ken Johnson

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?
Click to expand...

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

Ken Johnson
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range.Find problem 3
Ignoring cells using IF 1
Help with Index formula 2
#NAME? on correct formula 4
in a macro how to make a part of the formula a variable 3
Copy specific cells to another tab 6
VBA formula too long? 2
Summing a range of cells based on criteria in another range 2

Top