Forum Discussion
Solved
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 or equal to 24 then do nothing (or make C11 blank)
Not used the IF function very much so any help would be awesome!
Thanks
- 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
2 Replies
- 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
