Forum Discussion
T_Dawg69
Jan 11, 2020Copper Contributor
If Formulas
Cell C10 is a number from the result of an autosum of C4 thru C9. Based on the number from C10, I want C11 to: IF C10 is greater than or equal to 25, then add 15 to that number. If C10 is less than...
- Jan 11, 2020This will show the value of C10 if it is less than 25, but it will add 15 to C10 if 25 or greater:
=IF(C10>=25,15,0)+C10
JKPieterse
Jan 11, 2020Silver Contributor
This will show the value of C10 if it is less than 25, but it will add 15 to C10 if 25 or greater:
=IF(C10>=25,15,0)+C10
=IF(C10>=25,15,0)+C10