Formula for calculated column

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".

Assuming that the Willing is boolean field. Then the below formula works for me.

=IF(AND(Willing=TRUE,Experience>2),CTC*1.1,CTC)

Make sure that the calculated column's data type is Number

• 1. Willing is a "Yes/ No (Checkbox Column). 2. Cannot I keep Calculated Column as Currency? Right now I have kept it as YES/ No checkbox for testing the formula. – Anand Aug 5 '16 at 6:40
• GOT THE ANSWER THANX – Anand Aug 5 '16 at 6:49
• Reading the following answers I replaced "YES" with the boolean value TRUE, and I got the required output. But then again can anyone tell me, Why it's not working with "YES"? – Anand Aug 5 '16 at 7:12
• Because deep down the value stored is not the TEXT string "YES", SharePoint is very loose about Types, so you even do not need =TRUE. ....................... You want to multiply CTC by 1.1 OR 1 So the Formula can be: CTC * IF(AND(Willing,Experience>2) , 1.1 , 1 ) – Danny '365CSI' Engelman Aug 5 '16 at 7:40

Use this

Increment =IF(AND([Willing]=TRUE,[Experience]>2),([CTC]*1.1),[CTC])
• GOT THE ANSWER THANX – Anand Aug 5 '16 at 6:49
• Reading the following answers I replaced "YES" with the boolean value TRUE, and I got the required output. But then again can anyone tell me, Why it's not working with "YES"? – Anand Aug 5 '16 at 7:12
• the lists does not keep "yes"/"no" string for the checkbox. it keeps true/false – Tarek Salah uddin Mahmud Aug 5 '16 at 7:33
• You can also keep the increment field as currency. better practice is keeping both CTC and Increment as Same Type – Tarek Salah uddin Mahmud Aug 5 '16 at 7:36