If Function assistance

[Tortoisegong]

Hi, I want to create a function using IF with formula. Can someone help?  Below is the example.

I want to create a formula like below. 

Value - to be entered by user ( this is Cell B5).  If the value is 10000, it will be 100000*0.15%. and if the results is more than 30, the results will be 100000*0.15% which is 150.

Results = =IF(B5*0.15%<30,"30")... what will be the formula behind this?

Thanks

Best regards

[#2]

Hi @Tortoisegong 

The formula should read like this 

=IF(B5*0.15%>30,100000*0.15%,30)

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more