ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formula (https://www.excelbanter.com/excel-worksheet-functions/100046-formula.html)

Mike

Formula
 
I need the
=IF(AND(H126=4001,H128=0%),100%*(H129),IF(AND(H1 26=3251,H126<=4000,H128=5%),50%*(H129),0))


Need only the 5% the except a positive or negative 5%

Dav

Formula
 

What do you need. Can you explain it more clearly

Need only the 5% the except a positive or negative 5%
what does the above mean ?

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=562717



All times are GMT +1. The time now is 11:13 AM.

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