If Function assistance

Occasional Visitor

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?



Best regards

1 Reply

Hi @Tortoisegong 


The formula should read like this 




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