Formula
You could do this:
=IF(B42<0.02,5,10)*B42 but obviously you can't put the formula in B42 itself. Hope this helps. Pete On Jul 28, 1:18*am, Jules wrote: this is the logic I need put into a formula * * If B42 < 2%, multiply it by 5. If = 2%, multiply by 10 |
All times are GMT +1. The time now is 06:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com