advanced if function

%3CLINGO-SUB%20id%3D%22lingo-sub-2250105%22%20slang%3D%22en-US%22%3Eadvanced%20if%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2250105%22%20slang%3D%22en-US%22%3E%3CP%3Ehi%20I%20am%20trying%20to%3C%2FP%3E%3CDIV%20class%3D%22page%22%3E%3CDIV%20class%3D%22layoutArea%22%3E%3CDIV%20class%3D%22column%22%3E%3COL%3E%3CLI%3E%3CP%3E%3CSPAN%3EIn%20column%20L%20of%20the%20Accounts%2C%20worksheet%20compute%20the%20%3C%2FSPAN%3E%3CSPAN%3EInsurance%20Coverage%20%3C%2FSPAN%3E%3CSPAN%3Eusing%20if%20function%2C%20if%20the%20customer%20has%20insurance%2C%20this%20is%20the%20%3C%2FSPAN%3E%3CSPAN%3EFinal%20Charge%20%3C%2FSPAN%3E%3CSPAN%3Etimes%20the%20%3C%2FSPAN%3E%3CSPAN%3EInsurance%20Coverage%20%3C%2FSPAN%3E%3CSPAN%3Eamount%20on%20the%20Assumptions%20worksheet%2C%20otherwise%2C%20it%20is%200.%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2250105%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2250111%22%20slang%3D%22en-US%22%3ERe%3A%20advanced%20if%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2250111%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1015337%22%20target%3D%22_blank%22%3E%40maceyw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%2C%20no%20IF%20is%20necessary%2C%20like%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DK3*Assumptions!%24D%243*%0A(D3%3D%22Yes%22)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

hi I am trying to

  1. In column L of the Accounts, worksheet compute the Insurance Coverage using if function, if the customer has insurance, this is the Final Charge times the Insurance Coverage amount on the Assumptions worksheet, otherwise, it is 0.

1 Reply

@maceyw 

Perhaps, no IF is necessary, like this:

=K3*Assumptions!$D$3*
(D3="Yes")