Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel 2003
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel 2003
Resolved · Low Priority · Version 2003
Reply Sun 26 Dec 2010, 16:59Delegate Katsura said...
Katsura has attended:
Excel Intermediate course
Powerpoint Introduction course
Excel 2003
Could you let me know how to create formula, page16 question 4, for Excel 2003 Intermidiate book.
For upcoming training course dates see: Pricing & availability
RE: 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
Attached files...
Practice Conditional_Results.xlsWill be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
Tue 11 Jan 2011: Automatically marked as resolved.
|