Greater than or equal too IF function

Hi,

Simply put the equal sign (=) after the greater than (>) sign. For example, if you want return "Yes" if the value in cell C1 is equal to or greater than 5, else return "No", use the following formula:

=IF(C1>=5,"Yes","No")

As long as there are no more than 3 colour conditions, use Conditional Formatting from the Format menu to colour code the different scenarios. You might find that you then don't need the IF formula in a different cell. See the attached screen shot for clarification.

Have a look at http://www.uwec.edu/help/Excel03/ws-hide.htm for hiding cells. Once you master Conditional Formatting, you may also consider changing the font colour of the cell(s) to the same colour of your spreadsheet (generally white) if it meets a certain condition. This will also 'hide' the cell contents when the sheet is printed.

Hope this helps.

Kind regards,

Robert

Originally Posted by Bryan Hessey

Hi,

for the 'hidden', in (rightmouse) Format Cells, Protection there is a 'Hidden' option to apply when the sheet is Protected.

hth
---

I tried that but they still showed. Never mind that wasnt all that important.

The IF function is now working fine too thanks.

As stated above you can use conditional formatting to chang the font to white.

Another option is to select the cells you want hidden, go to Format > Cells (CTRL+1), on the Numbers tab, select Custom, and in the Type: box enter ";;;" (without the quotes). Using this option, it is a good idea to make sure the cell property is Hidden and protect the sheet. This way the values won't appear on the formula bar.