I have a really long formula that works perfectly except for one thing. Here
is the formula below, it looks complicated but its just the same couple
formulas over and over for different cells. One thing I am trying to do is if
b8= "" or 0, then I want the output to ignore A8 otherwise let the formula
continue. So basically if there is nothing in B8 then I dont want the output
to spit out the contents in A8.

=IF(A8<0,A8&"\r","")&IF(B8<0,B8*100&"\r","")&IF( A8=11302,$G$1&"\r","")&IF(A8=1302,$G$1&"\r","")&IF (C8<0,C8&"\r","")&IF(J8="Y",J8&"\r","")&IF(J8="N" ,J8&"\r","")&IF(A8<0,IF(D8<0,D8&"\r",""),"")&IF( F8<0,F8&"\r","")&IF(G8<0,G8*-100&"\r","")&IF(F8=11302,$G$1&"\r","")&IF(F8=1302, $G$1&"\r","")&IF(H8<0,H8&"\r","")&IF(K8="Y",K8&"\ r","")&IF(K8="N",K8&"\r","")&IF(F8<0,IF(D8<0,D8& "\r",""),"")