IF opposite cell is more than 13.5% - make actual cell 0

[JDMBoy36]

Hi All,
Please help with the below as i am currently still learning formulas

J11 =IFERROR(E11*SUM(G11,I11),"-")

F11 - 13.5%

I need to add a formula in J11 and activate should F11 be 13.5% or more, J11 will turn into the numeral 0

Thanking all in advance for the help

[samba_ravi]

=IFERROR(IF(F11>=E11*SUM(G11,I11)*13.5%,0,E11*SUM(G11,I11)),"-")
Try this

[rajansettu]

Hi Try the below formula

Please Login or Register  to view this content.

[JDMBoy36]

Thank you for the reply, however once i insert 11% and above in the cell, it goes 0. If i insert 10% and below it gives me the correct figure?
any reason as to why this is happening?

Thank you all in advance.

[rajansettu]

hi its because F11 value is less than J11..

[JDMBoy36]

hi its because F11 value is less than J11..

The figure in J11 is a currency figure and F11 is a % figure... does this still apply?

[rajansettu]

hi will you attach the sample work sheet for referance

[JDMBoy36]

Hi Guys,

Both formulas worked ! The fault was on my side as i didnt wait for the page to refresh.
To conclude, both formulas answered my question.

Thank you all !