Forum Discussion

Darren Kulback's avatar
Darren Kulback
Copper Contributor
Jan 19, 2018

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

Resources