Question about Microsoft Office Professional 2007 Full Version for PC

1 Answer

Excel help I am trying to do a function on excel, I want one cell to read cell that contains text then give me a final numerical amount. The unsuccessful equation I am using right now says =IF(F14="toilet",SUM(F16*0.3)) what I want is to be able to type any kinds of words into F14 and only if I type the word toilet for the rest of the equation to multiply itself out. Also I want to be able to type other words besides "toilet" and have the equation still work. Let me know if there is a way for me to do this. Thanks, Jack

Posted by on

1 Answer

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    MVP:

    An expert that got 5 achievements.

    Scholar:

    An expert who has written 20 answers of more than 400 characters.

    Hot-Shot:

    An expert who has answered 20 questions.

  • Expert
  • 70 Answers

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

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

Need to have a certain cell say OFF when it is a certain day


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.

Jun 06, 2010 | Microsoft Excel for PC

3 Answers

NEED TO AVERAGE CELLS, WHERE ONE OR MORE CELLS CONTAIN ''0'' OR ''#D


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))

Aug 26, 2009 | Microsoft Office Excel 2007

1 Answer

When I create a formula in a cell, hit enter, I get #VALUE. How do I get the actual result to appear, instead of #VALUE?


#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

2 Answers

Writing a formula for a sumif problem


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.

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

1 Answer

Importing Excel file into Act 2006 Version8


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.

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

2 Answers

Excel text boxes


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). 5e70363.jpgChoose 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.
c72d4bc.jpg 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).
466bdaf.jpg dcf40c0.jpg 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

1 Answer

Using if and then to add values to a cell


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

Dec 09, 2007 | Business & Productivity Software

2 Answers

When I enter a formula in a cell with the the insert functon device, it does not calculate itself, but shows as text


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

2 Answers

FORMULA FOR TEXT FORMATING


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

Nov 29, 2007 | Microsoft Excel for PC

1 Answer

Numaric to TEXT


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

Not finding what you are looking for?
Microsoft Office Professional 2007 Full Version for PC Logo

Related Topics:

74 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Business & Productivity Software Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Les Dickinson
Les Dickinson

Level 3 Expert

18297 Answers

Sudeep Chatterjee
Sudeep Chatterjee

Level 3 Expert

3267 Answers

Are you a Microsoft Business and Productivity Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...