answersLogoWhite

0

Yes you can do that. The main function to do that is the If function. See the link below for more information on it.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

To create a worksheet you enter information into cells?

Technically, a worksheet is a worksheet even if it is empty. To create a worksheet that will do calculations, then you would start to enter things into its cells.


In Excel you can create a worksheet that will be able to make decisions based on the information that appears in other cells. In what category of the Insert Function dialog box will you find functions?

The Logical category functions are the ones most appropriate, like the IF function, but some functions in other categories could be used too, like SUMIF in the Math & Trig category.


What is the new of a new worksheet in Excel?

Create a blank worksheet.


Can a chart be saved on the same worksheet as the data or on a separate worksheet?

A chart can be saved on the same worksheet or on a separate worksheet in Excel. The easiest way to put a chart on a separate worksheet is to create your chart on the same worksheet as your data. After you create your chart, just cut and past to the worksheet where you want it to show.


With a good understanding of the requirements document an understandind of the necessary deceions a d a sketch of the worksheet the next step is to?

use Excel to create the worksheet...good luck on your test:)


How do you create a shape in your Excel worksheet using the Shapes button?

Click on the shape you want and then click and drag over the worksheet to draw it onto the worksheet.


What can Excel do in addition to its worksheet capabilities?

it can create charts


What helps you create a chart from worksheet data?

chart wizard


What is a special workbook or worksheet you can create and then use as a pattern to create new similar workbooks or worksheets?

A template.


Can you create multiple charts based on the same worksheet data?

yes


Where can you create a worksheet of scrambled words?

put a bunch of letter in the page


How do you keep a pivot table from creating a new worksheet?

When creating a pivot table, you are given the option of placing it in a new worksheet or in the current one. So you just need to specify a cell in a blank area of the current worksheet. Then it won't create a new worksheet.