Thread: I want my formula to result in zero if referenced cell = 0, otherwise calculate
View Single Post
 
Old 12-21-2022, 11:10 AM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2019
Expert
  
Join Date: Apr 2014
Posts: 948
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
What you're asking for is:
=IF(V2>0,((V2-2000)*1.15)/1000,0)
but you probably want:
=IF(V2>2000,((V2-2000)*1.15)/1000,0)
or:
=MAX(0,((V3-2000)*1.15)/1000)
Reply With Quote