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
Dias Habsy's image
Dias Habsy
Feb. 17, 2018, 8:28 p.m.

Answers!

Maninder's image
Maninder
Feb. 17, 2018, 10:16 p.m.

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

 

Comment

Answer the question...

Dias Habsy's image