Hello!

I have a Microsoft Excel document used to calculate percentage options:

– For items that cost $20 or less I charge 20% but minimum $3

– For items that cost more than $20 but less than $35 I charge 15% but minimum $5

– For items that cost more than $35 I charge 10%, but minimum $8.

I’m looking for a formula to use for both the cell for the amount and the cell for the result, without using a third cell for the percentage.

Does anyone know how to do this? 

Hi!

I am working on a data entry project with Microsoft Excel and I have a problem. My data comes in two long columns:

In column 1A I have: SC-

In column 1B there could be any number made of 1 to 4 digits, sometimes combined with letters (e.g. 23, 32.65b or D48)

What I want is to add the numbers and letters in column 1B to the SC- in column 1A. This may be a very tedious process if I use the F2 key to do 1 row at a time.

I want to know if there’s any way to combine the two columns in A so I get mixed numbers and letters (e.g. SC-23, SC-32.65b etc.), leaving the B column untouched.

If you have any solution, please let me know

Hello!

I have Windows Vista installed on my computer and I can’t open an excel file received as attachment in an email. Every week I receive an email with updates and I can’t get to open the attachments.

Is there any problem with my connection?

Is there any way I could solve this problem? 

Hi! I want to know if I can access my corporate e-mail in Microsoft Outlook without being logged into the corporate VPN, the same way I can do it with Microsoft Entourage. To access the company’s Microsoft Exchange server through Entourage, I just have to point at the address I use for webmail. Can the same thing be done with Microsoft Outlook?

Hi!

I need some help with my Outlook.

The e-mails I send from my own address in the CC field do not reach the Outlook inbox, although they do appear in the webmail on Comcast and on the iPod Touch.

This issue occurred recently, as last week I was receiving them in Outlook, too. It doesn’t happen to e-mails received from other sources. I was wondering if they’re not quarantined for any reason.

Can anyone please tell me if there’s a particular setting I should make or if there’s a bug in Outlook?

Thank you. 

 Hi!

I use Outlook for my e-mail account and I’m wasting a lot of time deleting the messages; every time I delete a message that’s open, by default, Outlook takes me back to Inbox.

Does anyone know if there’s any way to make it go to the previous or the next in the list when deleting the message? 

Hi,

I want to know if for IMAP access where the username represents your account and the mailbox is a resource mailbox or another user’s mailbox. can I use an account name of this type: uiucusernamemailbox.

Please tell me if you know the answer.

I am experiencing a problem with my Microsoft Excel. Whenever I try starting a macro in an existing spread sheet, I encounter an error message saying “It appears that you have opened it using Internet Explorer.

Please download the spread sheet to your computer and open it using Excel”. It somehow worked after a long time but then it suddenly stopped working again.

I already tried looking at the file associations and I thought I saw something wrong but I still could not correct it.

I hope you’ll help me deal with this problem. Thank you. 

I am using Microsoft PowerPoint 2007 and I am having a problem in playing videos properly through it.

When I present, the only time I could play the video is after I clicked on the slides before and after the slide where the video is inserted. Doing this does not exactly impress the audience.

I really need help on how to work my PowerPoint properly so I wouldn’t have to click back and forth before I could play my videos the next time I do a presentation.

I hope you can help me. Thank you. 

My computer’s operating system is Windows XP and I am using Microsoft Office 2007 with it.

My trouble is whenever I open an Excel file; it opens but has no data on it. Microsoft Word works just fine but Excel does not.

I even tried uninstalling and reinstalling Microsoft Office 2007, and made sure that all updates are done to no avail.

I hope you could tell me what the problem is and how I could solve it. Thank you.