Thread: would like to know how the IF , and function would be created for a simple 2 column tax calculatio
View Single Post
 
Old 03-21-2023, 12:28 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
=sum(D8,E8)*(9.975/100)
In case you don't want zeroes displayed
=IF(sum(D8,E8)>0, sum(D8,E8)*(9.975/100),"")
Reply With Quote