# 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. Aug 5, 2016 at 6:40
• GOT THE ANSWER THANX Aug 5, 2016 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"? Aug 5, 2016 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 )` Aug 5, 2016 at 7:40

Use this

``````Increment =IF(AND([Willing]=TRUE,[Experience]>2),([CTC]*1.1),[CTC])
``````
• GOT THE ANSWER THANX Aug 5, 2016 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"? Aug 5, 2016 at 7:12
• the lists does not keep "yes"/"no" string for the checkbox. it keeps true/false Aug 5, 2016 at 7:33
• You can also keep the increment field as currency. better practice is keeping both CTC and Increment as Same Type Aug 5, 2016 at 7:36