ExcelBanter

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

Pete_UK

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