The question is:- If an employee is willing
for an increment and his experience is more than 2 years
, then the increment rewarded should be 10% of the current CTC(Cost to Company)
. For this, I wrote the formula as
Increment
=IF(AND([Willing]="YES",[Experience]>2),([CTC]*1.1),[CTC])Just for checking I have kept calculated as YES/NO Checkbox. Therefore:- ([CTC]*1.1)= YES and [CTC]= NO.
Can anyone tell me what's wrong in the formula? Because no matter what the input is, the output is always "NO".