If basic<10000 calculate gross=DA+basic, if basic>=10000 and <20000 , calculate
gross=DA+basic+50% of HRA, if basic >=20000, calculate gross = basic+DA+HRA
Can anyone suggest google sheet formulae?
if(basic < 10000 )
{
gross = DA + basic
}else if(basic >= 10000 && basic < 20000)
{
gross = DA + basic + (0.5 * HRA)
}else
{
gross = DA + basic + HRA
}
>Solution :
Just plug it to an IF formula.
=if(basic < 10000, DA + basic, if(and(basic >= 10000, basic < 20000), DA + basic + (0.5 * HRA), DA + basic + HRA))