Excel 2003

Hello Katsura,

Hope you enjoyed your Microsoft Intermediate course with Best STL.

Thank you for your question regarding creating an IF formula.

I have created a copy of the Excel file for you with the formula given for you to re-create yourself. Give it a try and no doubt you will be successful. Just in case you fail to get the file the formula which should be created into G6 is as follows:

=IF(F6>=$J$4,F6*$K$4,$K$5)

Copy this down into the cells below.

I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer