Question about Microsoft Office Professional 2007 Full Version for PC

Maybe this is what you need:

=IF(A1="toilet",(B1*2),(IF(A1="bread",(B1*3),(IF(A1="star",(B1*4))))))

this is called "nested".

You can put nested if function maximum 7. (for more than 7, we should make another "trick")

if you put toilet in A1 then come the value B1*2

if you put bread in A1 then come the value B1*3

if you put star in A1 then come the value B1*4

Note: SUM(F16*0.3) is wrong. should be only (F16*0.3) or if you want to do sum --> SUM(F16:F20)

Posted on Apr 02, 2008

Use the **test** function.

Formula in cell A1 would be**=text(a2,"dddd").**

This would pick up the date from cell A2 and return the day of the week in cell A1.

Formula in cell A1 would be

This would pick up the date from cell A2 and return the day of the week in cell A1.

Jun 06, 2010 | Microsoft Excel for PC

Try this. If any of the cells are zero (or blank), the word 'zero' will be displayed. Substitute anything you want for the text including blank ""

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

=IF(OR(F61=0,J61=0,N61=0),"zero",AVERAGE(F61,J61,N61))

Aug 26, 2009 | Microsoft Office Excel 2007

#VALUE? is an error indication meaning that Excel can't process the formula. It is most likely the result of a bad cell reference in your formula, for example, you may be trying to perform mathematical operations on a cell that contains non-numeric text data.

Jul 21, 2009 | Microsoft Office Excel 2007

Brenda,

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:

- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear

- Use this formula =SUMIF(E8:E26, 1, H8:H26)

For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.

Your problem is not so much the formula but the cells that contain the hours for each call. Since they contain the text “hrs” (for example “2.25hrs”) this turns the whole cell to text, not numeric, which will always add up to zero in Excel. So do two things:

- Change the cells in column H (Time Spent) to numeric (2.25 instead of 2.25hrs) – you might want to change the column header to Time Spent In Hrs just to b clear

- Use this formula =SUMIF(E8:E26, 1, H8:H26)

For the formula change the middle number to correspond to the operator ID – for example for operator 2 change the formula to =SUMIF(E8:E26, 2, H8:H26)

This should do it.

BTW, sent you a similar email about this.

May 07, 2009 | Microsoft Excel 2007 Home and Student...

My advice is not specific to Sage, but exoprting Excel data.

Check there are no missing/ blank cells within the range, anything that is blank change it to 0.

Make sure the format of your range matches the character length allowed in Sage - Especially for text - if necessary check the no of characters using =LEN(B2) - Assuming B2 contains the text you are checking, where necessary trim the no of characters.

Change your format to CSV if possible, sometimes easier to import.

If you do the above and receive an error message or can narrow down the issue it will give me a better idea of why the import is failing.

Check there are no missing/ blank cells within the range, anything that is blank change it to 0.

Make sure the format of your range matches the character length allowed in Sage - Especially for text - if necessary check the no of characters using =LEN(B2) - Assuming B2 contains the text you are checking, where necessary trim the no of characters.

Change your format to CSV if possible, sometimes easier to import.

If you do the above and receive an error message or can narrow down the issue it will give me a better idea of why the import is failing.

Mar 23, 2009 | Sage ACT! 2006 Full Version for PC

If you are talking about deleting the text boxes at a time that have been inserted to your cell of excel worksheet, plz follow the steps.

STEP-1

1. Open your excel sheet where the textboxes are inserted.

2. You can click one of the text box (do not click in the cell).Now press control and select the other ones with the mouse.

3. Now press the delete key and your box will be deleted.

else if you want to delete all at a time follow this.

STEP-2

1. Open your excel worksheet that contain text boxes. Now right click on the blank area of Menu bar (At top right corner area). Choose Drawing tool bar if not selected. Now from the drawing toolbar (above the TASK BAR) choose the --> (arrow mark) at bottom left corner of the drawing bar.

2. Now your mouse pointer will be changed to arrow shape. Now click on the bigining of the excel sheet and drag till the page end without releasing your mouse button. Now you will see all the text boxes will be selected.(No text will be selected, Only objects will).

3. Now press delete key and all your text boxes will be deleted at a time.

Hope it works, otherwise mail mei will give you the screen shots.

STEP-1

1. Open your excel sheet where the textboxes are inserted.

2. You can click one of the text box (do not click in the cell).Now press control and select the other ones with the mouse.

3. Now press the delete key and your box will be deleted.

else if you want to delete all at a time follow this.

STEP-2

1. Open your excel worksheet that contain text boxes. Now right click on the blank area of Menu bar (At top right corner area). Choose Drawing tool bar if not selected. Now from the drawing toolbar (above the TASK BAR) choose the --> (arrow mark) at bottom left corner of the drawing bar.

2. Now your mouse pointer will be changed to arrow shape. Now click on the bigining of the excel sheet and drag till the page end without releasing your mouse button. Now you will see all the text boxes will be selected.(No text will be selected, Only objects will).

3. Now press delete key and all your text boxes will be deleted at a time.

Hope it works, otherwise mail mei will give you the screen shots.

Feb 16, 2008 | Business & Productivity Software

Try using the SUMIF function for one condition or multiple conditions. Use the SUMIF worksheet function to create a total value for one range based on a value in another range. For example, for every cell in the rage B5:B25 that contains the value "Northwind", the following formula calculates the total for the corresponding cells in the range F5:F25. Formula:

=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

=sumif(B5:B25,"Northwind",F5:F25)

Here are SUMIF functions for multiple conditions.

=sum(if((B5:B25="Northwind")*(C5:C25="Western"),F5:F25))

=sum(if((B5:B25="Northwind")+(C5:C25="Western"),F5:F25))

=sum(if(B5:B25="Northwind",IF(C5:C25="Western"),1,0)))

Also check your help for SUMIF functions.

If this helps you, Please rate me. Thanks, Patty

Dec 09, 2007 | Business & Productivity Software

Is there by any chance a space or any other character before the equals sign? That could cause your formula to display as text.

Dec 03, 2007 | Microsoft Excel for PC

Yes of course, if you have a little background of visual basic programming that's possible you can enhance your requirements.

Please see link http://www.techonthenet.com/excel/questions/cond_format1.php

Please see link http://www.techonthenet.com/excel/questions/cond_format1.php

Nov 29, 2007 | Microsoft Excel for PC

Raju, There's no easy way to do it as far as I know.
What you can do is create a table where in column A you'll have the sum, in this case 300 and in column B you'll have the text i.e. Rupees Three Hundred Only
Then you need to use the Vlookup function to retrieve the right text to the number you get.

Sep 15, 2007 | Microsoft Office Standard for PC

74 people viewed this question

Usually answered in minutes!

×