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) |
=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