would like to know how the IF , and function would be created for a simple 2 column tax calculatio

Kwmck328 · #1 03-20-2023, 07:21 PM

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 ???

ArviLaanemets · #2 03-21-2023, 12:28 AM

=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),"")

Kwmck328 · #3 03-21-2023, 06:18 AM

Thank you.... I used the IF statement,,,

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
best smart art or other function for simple graph	redalert787	PowerPoint	0	09-17-2019 05:24 AM
Perform function when t-character is entered in Column-A	SerenityNetworks	Excel Programming	3	12-22-2017 09:24 AM
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
Formula/function to return column names for matching values	GiJoe81	Excel	1	06-27-2015 12:13 AM
a function that deletes all rows with no value in a certain column?	dunndealpr	Excel	2	06-08-2013 06:50 AM