C changetires Jun 27, 2006 #1 I want to write this as a formula: 1 minus F6 divided by F6 plus Z6 plu AA6, but only if AA6 is less than zer
I want to write this as a formula: 1 minus F6 divided by F6 plus Z6 plu AA6, but only if AA6 is less than zer
G Guest Jun 27, 2006 #2 =if(aa6<0,(1-f6)/(f6+aa6),0) This will return 0 if aa6 is not less than 0. Replace the 0 with whatever you want if aa6 is not less than 0. Shaun
=if(aa6<0,(1-f6)/(f6+aa6),0) This will return 0 if aa6 is not less than 0. Replace the 0 with whatever you want if aa6 is not less than 0. Shaun
