So I've got a formula computing some values...

basically if

cell column J has <1.5 Million then 5% x column J

cell column J has >=1.5 Million but <3 Million then 10% x column J

cell column J has >=3 Million but <10 Million then 15% x column J

cell column J has >=10 Million then 20% x column J

I know I can use the below formula... and fill the column BUT I would rather have it be computed and just a value returned.

=IF(J2>=10000000,ROUNDDOWN(J2*0.2,1),IF(AND(J2>=3000000,J2<10000000),ROUNDDOWN(J2*0.15,1),IF(AND(J2>=1500000,J2<3000000),ROUNDDOWN(J2*0.1,1),IF(J2<1500000,ROUNDDOWN(J2*0.05,1)))))

Thanks

mpham

basically if

cell column J has <1.5 Million then 5% x column J

cell column J has >=1.5 Million but <3 Million then 10% x column J

cell column J has >=3 Million but <10 Million then 15% x column J

cell column J has >=10 Million then 20% x column J

I know I can use the below formula... and fill the column BUT I would rather have it be computed and just a value returned.

=IF(J2>=10000000,ROUNDDOWN(J2*0.2,1),IF(AND(J2>=3000000,J2<10000000),ROUNDDOWN(J2*0.15,1),IF(AND(J2>=1500000,J2<3000000),ROUNDDOWN(J2*0.1,1),IF(J2<1500000,ROUNDDOWN(J2*0.05,1)))))

Thanks

mpham

Last edited: