0

Subjects>Electronics>Computers

How do you write a formula in cell b1 in excel that shows if cell a1 is greater than 4 enter the number 150 or if cell a1 is less than 4 enter 75?

Anonymous

∙ 13y ago

Updated: 12/12/2022

=IF(A1>4,150,75)

In this case if A1 is 4, then 75 will show. If you want 150 to show when A1 is 4 then the formula would be:

=IF(A1>=4,150,75)

Wiki User

∙ 13y ago

What else can I help you with?

Related Questions

What type of entry does Excel assume you are?

Excel assumes data is text initially, but can treat it differently depending on the way you enter it. That is why you enter an equals sign at the beginning of a formula to indicate to Excel that you are creating a formula.

Where does excel display the data as you enter it?

in the cell and in the formula bar

What is it called where excel displays data as you enter it?

formula bar

How you enter account no in Excel sheet it not except?

This question is not clear. You can enter a number in Excel by clicking on a cell and typing the number from the keyboard.

What is the area of the excel window in which you enter and edit data?

cell or formula bar!

What is a number that can be entered into a cell on Excel?

Which of the following is a number that can be entered into a cell?

When you enter a formula in a cell Excel assigns the cell the same format as the cell reference in the formula?

first

How do you enter Euler's number into excel?

=exp(1)

What is a formula bar used for in Excel?

To enter the formula in selected cell, To view the farmula or content of selected cell.

How do you enter an array formula?

After you enter your formula, press CTRL+SHIFT+ENTER at the same time. You will see the array formula displayed with brackets ({}) around it. If you type the same text, including the brackets and press just ENTER, you will not tell Excel the formula is an array and may display only text. You need to enter the formula, without the brackets, and press CTRL+SHIFT+ENTER to let Excel know it is an array. See related links for more details about array formulas.

Where is the enter box in Excel?

The Enter box is the green tick that appears beside the formula bar when you are entering or editing a cell.

What is the excel formula symbol for any number?

1()

Trending Questions

What kind of job can you get with a network plus certification? Why does yellow ink run out before other colors? What is a feature that applies the formats associated with a selection to another selection? How can you open this file extension jpg 128x96? Which it is that is allowed by FTP sites whereby anyone can transfer some if not all available files? At which heirarchical layer are switches normally not required to process all ports at wire speed? What does smart-tv full web browser do? When data applications and resources are stored on servers rather than users computers it is referred to as what? How do you run ffmpeg in command prompt? What is the key boards official name? What software does sabrepulse use? What does layout refer to in excel? How did the ISM radio band encourage expanded use of wireless devices? What is the history of the handshake? What does striking the return key once mean? Which command entered without arguments is used to display a list of processes running in the current shell? How man oz in a 750 ml bottle? The usb and firewire bus standart and their possible impact on computer of the future? How do you program frequencies on the bear-cat scanner bc147xlt? What is the magnetic and fragile metal that copper wire is wrapped around in a CRT TV?

Resources

Top Categories

Product

Company

Copyright ©2025 Answers.com | Lunias Media Inc. All Rights Reserved. The material on this site can not be reproduced, distributed, transmitted, cached or otherwise used, except with prior written permission of Answers.