how do I create a if-then formula?
I need to create a formula in which if column a is bigger then b, then
subtract the two columns and multiply by 3%, or if column b is bigger then find the difference and multiple by 5%. |
Put this in C1
=IF(A1B1,3%,5%)*(A1-B1) and copy down -- Regards - Andy Wiggins FCCA www.BygSoftware.com Excel, Access and VBA Consultancy "karen" wrote in message ... I need to create a formula in which if column a is bigger then b, then subtract the two columns and multiply by 3%, or if column b is bigger then find the difference and multiple by 5%. |
All times are GMT +1. The time now is 09:49 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com