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

		Microsoft Office Forums > Microsoft Excel > Excel
would like to know how the IF , and function would be created for a simple 2 column tax calculatio

03-21-2023, 12:28 AM

ArviLaanemets ArviLaanemets is offline

Windows 8

Office 2016

Expert

Join Date: May 2017

Posts: 960

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:55 PM.