Forum Discussion

Copper Contributor

Feb 27, 2019

Solved

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

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

excel

Haytham Amairah
Feb 27, 2019
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

Haytham Amairah

Silver Contributor

Feb 27, 2019

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