ExcelBanter - Add to IF formula

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Add to IF formula (https://www.excelbanter.com/excel-worksheet-functions/107923-add-if-formula.html)

Seti

Add to IF formula

Here is the current formula =IF((M7*2.5)250000,250000,(M7*2.5))

What I want to do is have this formula but also if h7 is greater than or = to 65 multiply m7 by 2.5 and then by .65

All times are GMT +1. The time now is 08:51 PM.