LoveByPDF logo

LoveByPDF
EN

India & payroll · MIN, MAX

"Whichever is lower / higher" in Excel - MIN and MAX of two values

Payroll and tax rules often say "A or B, whichever is lower" - that is MIN(A,B); "whichever is higher" is MAX(A,B).

=MIN(value1, value2)   =MAX(value1, value2)
Write it for my sheet

Examples

Type this in the Formula StudioFormula
“basic or 15000 whichever is lower”=MIN(D2,15000)
“12% of basic or 15000 whichever is lower”=MIN(D2,15000)*12%
“D2 or E2 whichever is higher”=MAX(D2,E2)

Tips

  • PF on a wage ceiling: 12% of basic or the ceiling, whichever is lower, is =MIN(Basic,15000)*12% - check the ceiling that applies to you.

People also search for

  • excel formula for whichever is lower
  • whichever is lower formula in excel
  • whichever is higher formula in excel
  • whichever is less in excel
  • min of two values in excel
  • pf calculation formula in excel
  • 12% of basic or 15000 whichever is lower
  • hra exemption formula in excel
  • lower of two values excel
  • whichever is lower formula in hindi

FAQ

How do I write 'whichever is lower' in Excel?

Use MIN with both values: =MIN(D2,15000). For 'whichever is higher' use MAX: =MAX(D2,E2).

What is the PF formula on a 15000 wage ceiling?

12% of basic or of the ceiling, whichever is lower, is =MIN(D2,15000)*12% with basic in D2. Check the wage definition and ceiling that apply to you.

How do I write 'whichever is less' in Excel?

Use MIN: =MIN(first value, second value). For 'whichever is more' use MAX.

Can LoveByPDF write this formula for me?

Yes. Open your Excel file in the Excel Agent's Formula Studio, click a cell and type what you need - e.g. "basic or 15000 whichever is lower" - you get the formula, a preview on your sheet and an explanation, then insert it.

Related formulas