Forum Discussion
number breakdown to tiers
I am fairly new to Excel but have gotten myself through to understanding a good but. So, now I have this issue with a spreadsheet for a shared water well that I use for invoicing. Problem is that I c...
tryker23213 Try this:
Tier 1
=MIN(G5, 3000)
Tier 2
=MAX(MIN(G5 -3000,7000),0)
Tier 3
=MAX(G5 -10000,0)
FYI i believe your error was this:
Tier 2
=IF(G5<=3000, 0, IF( AND(G5>3000,G5<10000),G5 -3000,7000) )
or you could simplify to either of these:
=IF(G5<=3000, 0, IF(G5<10000 ,G5 -3000, 7000) )
=IFS(G5<=3000, 0, G5<10000 ,G5 -3000 ,TRUE, 7000 )