garypea123
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 221
- Office Version
- 365
- Platform
- Windows
Hi,
I am trying to create a formula which will do a SUMIF but then provide a different result if the answer is less than needed (without creating another cell)
Q12 = =SUMIF($L$12:$L$17,P12,M12:M17)
However, as an Example I would like Q12 to return a result of 20 if the actual result is 20...
R12 = =IF(Q12<20,20,Q12)
I can do this easily by creating another cell and applying an if statement. But can I this built into Q12 formula so I do not need to create a new cell?
I am trying to create a formula which will do a SUMIF but then provide a different result if the answer is less than needed (without creating another cell)
Q12 = =SUMIF($L$12:$L$17,P12,M12:M17)
However, as an Example I would like Q12 to return a result of 20 if the actual result is 20...
R12 = =IF(Q12<20,20,Q12)
I can do this easily by creating another cell and applying an if statement. But can I this built into Q12 formula so I do not need to create a new cell?