Feb 28 2020 02:30 PM
=IFS(D4<300,0,D4<=399.99,B4*6%,D4>399.99>499.99,B4*9%,D4>499.99<599.99,B4*13%,D4>599<699.99,B4*17%,D4>699.99<899.99,B4*22%,D4>899.99,B4*23%)
Why is this not working properly?
Feb 28 2020 02:42 PM
Feb 29 2020 11:32 AM
=IFS(D4<300,0,D4<=399.99,B4*6%,D4>399.99<499.99,B4*9%,D4>499.99<599.99,B4*13%,D4>599<699.99,B4*17%,D4>699.99<899.99,B4*22%,D4>899.99,B4*23%)@Abiola1@Abiola1 I have adjusted it however it returns #n/a now. Any idea why?
Feb 29 2020 11:36 PM
@Gavc1 Try it like this in stead.
=IFS(D4>=900,B4*23%,D4>=700,B4*22%,D4>=600,B4*17%,D4>=500,B4*13%,D4>=400,B4*9%,D4>=300,B4*6%,D4<300,0)
A reference like " D4>399.99<499.99 " will never work as it is fundamentally wrong. You would have to use something like " AND(D4>399.99,D4<499.99) ".
Mar 03 2020 01:52 PM