Formula to calculate percentage based on date and Value

I am trying to find an easy way to calculate super based on date and totals
In a Month if the total Gross exceeds $ 490 then 9.5% applies to each figure
If $ 490 is not reached [total] then the 9.5% does not apply
What I am seeking is that the formula looks at the total for the month and if it exceeds $ 490 then it calculates

I have attached an example sheet

Assistance appreciated

When I see SuperCalc, I think of an old spreadsheet program from the '80's. In no way does it explain what your question is, so I would ask you to please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem - not what you think the answer might be. (think google search terms?). Once you have done this please send me a PM and I will remove this request. (Also, include a link to your thread - copy from the address bar)

Many members search our previous posts, and thread titles play a big part of the search. I doubt anybody would do a search based on your title?

To change a Title on your post, click EDIT POST then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

I disagree with your comments.
My questions are valid and to me the spread sheet explains what I am trying to achieve
Perhaps the title could be better worded to say Formula to calculate percentage based on date and Value
Apart from that I think it's okay

Please read our rules regarding thread titles, I fail to see how Super Calc describes what your problem is. The tittle you have suggested would work.

Once you have changed your title, I have your answer ready for you.

Thanks

Read post #2

As do I...

To change a Title go to your first post, click EDIT then Go Advanced and change your title

Hi there again. try this out.

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.