Building a commission calculator for my broker

I am looking to build a commission calculator for my broker, to know how much I will incur in commission to execute a trade before actually doing it.

The criteria are:

$0.01/share (min. $4.95 to max. $9.95)

I attached an excel document as example.

thank you in advance!!

Assuming A1 = shares, =IF(a1<495,4.95,IF(a1<995,a1*0.01,9.95))

I am a beginner with excel, could you please make an excel sheet to use this function?
thank you for your time!

See attached.

it works great, thank you!