Forum Discussion
Darren Kulback
Jan 19, 2018Copper Contributor
USING IFS Function
I am a consignment store that takes different amounts based on how much money you have sold.
< 500 70% > 500 - 2500 60% > 2500 .55%
Here is my formula =IFS(D9<G3,(D9*H3),D9>G3,((G3*H3)+(D9-G3)*H4),D9>G4,((D9-G4)*H5)+G5)
I am getting a number that is slightly off.
when d9 = 2501 It should = 1550.55 but it shows up at 1550.60
Why would it round to .6?
No RepliesBe the first to reply