ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Function (https://www.excelbanter.com/excel-worksheet-functions/48441-function.html)

NewLearner

Function
 
I am trying to do a if, then statement

If (E3*3+D3*2) is greater than 12 then enter 12 otherwise give me the total
of the sum of (E3*3+D3*2)

Dave Peterson

=min(12,e3*3+d3*2)

or

=if((e3*3+d3*2)12,12,(e3*3+d3*2))

NewLearner wrote:

I am trying to do a if, then statement

If (E3*3+D3*2) is greater than 12 then enter 12 otherwise give me the total
of the sum of (E3*3+D3*2)


--

Dave Peterson


All times are GMT +1. The time now is 01:04 PM.

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