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-20-2023, 07:21 PM
Kwmck328 Kwmck328 is offline Mac OS X Office for Mac 2011
Novice
  
Join Date: Feb 2015
Posts: 23
Kwmck328 is on a distinguished road
Question would like to know how the IF , and function would be created for a simple 2 column tax calculatio
If D8 and/or E8 have $amount(s)>0 and tax is *9.975/100; total amount H8 = ?
D8 -$5.00
E8 - $20.00
H8 = Tax @ 9.975


=IF(D8:E8)*9.975/100 ???
Reply With Quote