Multiple IF statements

ahsansalik

Hi I have the following data

Department	Component	Action	Root Cause	Reason	Further Investigation
Electrical	Battery	Replaced	Not Rechargeable	Fail	Tv Remote
Electrical	Battery	Recharged	Excessive Use	Fail	Mobile Phone
Electrical	Battery	Recharged	Excessive Use	Fail	Game Controller
Electrical	Battery	Replaced	Not Rechargeable	Fail	Toy

I have written a code to change Reason and Device based on the Root Cause and Department

IF [Department] ='Electrical' and [Root Cause] = 'Not Rechargeable' OR [Root Cause]='Excessive Use' Then [Reason]= ' Battery Fail' 
else "Other" endif

IF [Department] ='Electrical' and [Root Cause] = 'Not Rechargeable' OR [Root Cause]='Excessive Use' Then [Further Investigation]= 'Battery Drained' 
else "Other" endif

Basically on the basis of the department Root cause combination i want to change the current values in Reason and Device
but its not doing what i need it to do

also i am getting confused with what quotes " and '  are used for "Battery" or 'Battery' what is the difference

apathetichell

These are two distinct formulas and need to be separated in the formula tool (ie click on the plus sign to open a second formula)... First has to create a new variable called Reason and it should read:

IF [Department] ='Electrical' and [Root Cause] = 'Not Rechargeable' OR [Root Cause]='Excessive Use' Then ' Battery Fail'
else "Other" endif

second variable is called further investigation and the formula is:

IF [Department] ='Electrical' and [Root Cause] = 'Not Rechargeable' OR [Root Cause]='Excessive Use' Then 'Battery Drained'
else "Other" endif

' and " are basically the same and only differ when you have an outer '" and you need to nest something...