How to add Round function with IF condition ?

[Jyotirmaya]

I want to add the ROUND function in the below code.
ROUND(L8,0)


L8 =IF(I8>=2,2*13500,IF(AND(I8=0,IK8<=2),6800*K8,IF(I8=0,6800*2,IF(I8+K8<=2,(I8*13500)+(K8*6800),IF(I8+K8>2,(I8*13500)+(6800*(2-I8)))))))

 

[KevCarter]

I want to add the ROUND function in the below code.
ROUND(L8,0)


L8 =IF(I8>=2,2*13500,IF(AND(I8=0,IK8<=2),6800*K8,IF(I8=0,6800*2,IF(I8+K8<=2,(I8*13500)+(K8*6800),IF(I8+K8>2,(I8*13500)+(6800*(2-I8)))))))

Please try:

=ROUND(IF(I8>=2,2*13500.3,IF(AND(I8=0,IK8<=2),6800*K8,IF(I8=0,6800*2,IF(I8+K8<=2,(I8*13500)+(K8*6800),IF(I8+K8>2,(I8*13500)+(6800*(2-I8))))))),0)

 

[Jyotirmaya]

Please try:

=ROUND(IF(I8>=2,2*13500.3,IF(AND(I8=0,IK8<=2),6800*K8,IF(I8=0,6800*2,IF(I8+K8<=2,(I8*13500)+(K8*6800),IF(I8+K8>2,(I8*13500)+(6800*(2-I8))))))),0)

thanks

 

[KevCarter]

Happy to help!