ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Tax Calculation (https://www.excelbanter.com/excel-worksheet-functions/191887-tax-calculation.html)

Abiathar

Tax Calculation
 
I wish to test one cell to find out whether it is below or a bove the value
in another cell and, depending upon the result include the data from two
further cells.
I'm using Excel 2007abiath

Bob Phillips[_3_]

Tax Calculation
 
=IF(A1B1,C1,D1)

--
__________________________________
HTH

Bob

"Abiathar" wrote in message
...
I wish to test one cell to find out whether it is below or a bove the value
in another cell and, depending upon the result include the data from two
further cells.
I'm using Excel 2007abiath





All times are GMT +1. The time now is 12:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com