SOLVED

IF Function (Logical Test, True Formula, False Formula)

%3CLINGO-SUB%20id%3D%22lingo-sub-358019%22%20slang%3D%22en-US%22%3EIF%20Function%20(Logical%20Test%2C%20True%20Formula%2C%20False%20Formula)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358019%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20use%26nbsp%3B%3DIF(A1%26lt%3B8000000)%2C(A1*0.05)%2C(8000000*0.05))%2C%20but%20it%20does%20not%20work.%3C%2FP%3E%3CP%3E%5BNumber%20Format%5D%20Cells%20A1%20%3D%2015%2C000%2C000%3C%2FP%3E%3CP%3E%5BNumber%20Format%5D%20Cells%20B1%20%3D%205%2C000%2C000%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExpected%20Result%3A%3C%2FP%3E%3CP%3EA1%20%3D%2015%2C000%2C000%20is%20more%20than%208%2C000%2C000%20%2C%20%22FALSE%22%20use%20function%208%2C000%2C000%20*%200.05%3C%2FP%3E%3CP%3EB1%20%3D%205%2C000%2C000%20is%20less%20than%208%2C000%2C000%2C%20%22TRUE%22%20use%20function%205%2C000%2C000%20*%200.05%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20help%20me.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-358019%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-358043%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20Function%20(Logical%20Test%2C%20True%20Formula%2C%20False%20Formula)%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-358043%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Albert%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20is%20a%20syntax%20error%20in%20the%20formula!%3C%2FP%3E%3CP%3EYou've%20closed%20the%20function%20in%20this%20point%20because%20of%20the%20right%20parenthesis%20after%208000000.%3C%2FP%3E%3CPRE%3E%3DIF(A1%26lt%3B8000000)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20need%20the%20remove%20the%20right%20parenthesis%20after%208000000%20as%20follows%3A%3C%2FP%3E%3CPRE%3E%3DIF(A1%26lt%3B8000000%2C(A1*0.05)%2C(8000000*0.05))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20no%20need%20to%20the%20parenthesis%20around%20%3CSTRONG%3EA1*0.05%3C%2FSTRONG%3E%20and%20%3CSTRONG%3E8000000*0.05%3C%2FSTRONG%3E.%3C%2FP%3E%3CPRE%3E%3DIF(A1%26lt%3B8000000%2CA1*0.05%2C8000000*0.05)%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi Experts,

 

I am trying to use =IF(A1<8000000),(A1*0.05),(8000000*0.05)), but it does not work.

[Number Format] Cells A1 = 15,000,000

[Number Format] Cells B1 = 5,000,000

 

Expected Result:

A1 = 15,000,000 is more than 8,000,000 , "FALSE" use function 8,000,000 * 0.05

B1 = 5,000,000 is less than 8,000,000, "TRUE" use function 5,000,000 * 0.05

 

Please help me.

1 Reply
Solution

Hi Albert,

 

There is a syntax error in the formula!

You've closed the function in this point because of the right parenthesis after 8000000.

=IF(A1<8000000)

 

You need the remove the right parenthesis after 8000000 as follows:

=IF(A1<8000000,(A1*0.05),(8000000*0.05))

 

Also, no need to the parenthesis around A1*0.05 and 8000000*0.05.

=IF(A1<8000000,A1*0.05,8000000*0.05)

 

Hope that helps