0
How do you format a row of cell -in Excel-to show a certain word based on the value of a cell in another row?
KellyFife
If your inventory is in column A1, put this in column B1: =IF(A1<30,"ORDER","OK")
(you can even copy and paste it down and it should work for them all)
To be really slick, put your inventory in column A, then in column B put your target inventory number, then do this in column C =IF(A1<B1,"ORDER","OK")
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
Can you upconvert video games?
There is no reason to upconvert the signal from a game console. While TV is shot in a certain format, transmitted in another, and displayed in yet another. A game is rendered live and displayed based on the detected TV.
What is the standard science investigatory format?
Evidence based.
How do you use xlaunchpad?
Xlaunchpad makes the a windows based format operate as a Mac based format. You need to install the app, run it, and then drag and drop shortcuts where you want them.
What kind of format is OpenDocument?
OpenDocument is an XML based file format. The advantage of using an XML format is that OpenDocument files are universally compatible with any word processing software.
How much can you get in student loans based on a certain salary?
how much can i get in student loans based on a certain salary
What is a Data Interchange Format File?
The Data Interchange Format (DIF) file format is a text based format encoded in ASCII with a header, for integrity checking, and a body. The format was originally developed by Software Arts in order to transfer data from VisiCalc, the first spreadsheet.
What format changes the appearene of cell range based on critera?
Conditional Formatting.
What style is the format style that excel assigns to all cells in a work book?
The default format style that Excel assigns to all cells in a workbook is the General format. This format displays numbers as they are entered and adjusts automatically based on the content of the cell.
What is a stereotype statement?
A stereotype is a judgement about another based on suferficial details and common misconceptions. Saying people of a certain race or gender are more likely to do this or that are examples of stereotypes.
Is a popular format for web based video that requires Adobe Flash Player?
Flash video
Is a popular format for web-based video that requires adobe flash player?
Flash video
What file format reduces the number of colors based on a user-adjusted sliding scale?
Jpeg
