HOW TO ADD VALUE IN A GIVEN RANGE OF CELLS WHICH MEETS STATED CRITERIA IN EXCEL
- ADD A BONUS OF 10 WHO >=50 OTHERWISE AND 5
Hi
Suppose Cell is C4
=if(C4>=50,10,5)
Learn more about If command here
https://www.teachoo.com/712/222/Simple-If-Command-/category/If-Command/
Regds
Maninder