mercredi 16 août 2017

Excel IF statement with multiple conditions

I'm trying to combine multiple IF statements and I can't get it to work. What it should kind of do is the following:

If X=0 and Y>0, return 10000 OR if X>0 and Y=0, return -10000 if neither do nothing.

I have 2 columns with 7000 rows and i want to calculate the fold change between the 2. I am doing that by

=IF(CA2<1;-1/CA2;CA2)

so that 0.9 turns into -1.1. however if you have a value of 0 you get a #div/0! error. I was hoping to work around by giving single regulated values either a +10000 or -10000.

I hope someone can help with this.

Aucun commentaire:

Enregistrer un commentaire