If Function assistance

Highlighted
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?

 

Thanks

Best regards

1 Reply
Highlighted

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