# Excell Conditional Formula

=IF(E5<=36,E5-7,"")=IF(E5>36,E5-9,"")

Posted by on

• wstring Mar 17, 2008

I still had a problem with the solution as a negative number is viewable before I enter a number, so I came up with this and was wondering if there was a shorter version?

=IF(E5<28,"",IF(E5<45,E5-7,IF(E5>44.5,E5-9)))

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Expert

=IF(E5>36,E5-9,E5-7)

Posted on Mar 15, 2008

• Leonard Muvai Mar 18, 2008

No thats the only way u can go around it

×

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### IS THERE A FORMULA IN EXCEL THAT WILL HIGHLIGHT CELLS THAT MATCH A NUMERICAL INVENTORY LIST?

One way would be to create a colunn C and use the formula: =COUNTIF(B\$2:B\$200,A2) in cell C2. Then copy the formula down to C200. (assuming you have 200 entries in B...). This will put a "1" next to every number in Column A that has a match in column B. Then you could put a conditional formula in column A that will highlight the cell if the value in column C is equal to 1. Alternatively you could also simply filter for 1's in column C and then manually highlight the cells that show up in A!

Sep 16, 2014 | Microsoft Excel for PC

### Excel Conditional Formatting: how do I make one cell highlight based on whether or not another cell is blank?

option: formula is
formula: =(datecell="")
select formatting of choice

Highlight the order cells, go to >format>conditional formatting, choose "formula is" instead of "cell is". When you refer to the datecell, use the first date cell in the column only, and do not use \$ signs.

Jan 09, 2013 | Microsoft Excel Computers & Internet

### I need a formula length of service in DD/MM/YY on MS Excell

Format cells A1 and B1 to dates.

A1 is the first date
B1 is the 2nd date
C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

Jun 23, 2011 | Microsoft Excel for PC

### I want to know how I can to apply the formula where the excell find one data and multiply for one data of other cell, what formula can I apply for my question?

Enter data the number 10 on cell A1. Enter data the number 20 on cell B2. Mouse click on cell C3. Press equal sign, press left arrow, press *, press left arrow twice, press enter. Mouse click on cell C3. You'll see your formula on the address bar. Hope this helps.

Mar 06, 2009 | Microsoft Office Excel 2003 for PC

### Need Formula

TEXT CASE
Convert to UPPER, Proper or lower
Auto Convert to UPPER, Proper or lower
Stop VBA Being Case Sensitive

SELECT CASE VBA
Select Case Statement. Great alternative to Else If Statements

CONVERSION
VBA: CBool(),CByt(),CCur(),CDate(),CDbl()Double,CDec(),CInt(),CLng(),CSng(),CStr(),CVar().
Example
dDate=cDate("25-Jan-07")
Convert Numbers to Words
Convert Numbers to Dollar Amount in Words
Spreadsheet Converter. Versions: HTML/JavaScript,Excel ASP.Net and Excel Java/JSP. \$
SQL Database Migration \$
Converters. Database Converters, Spreadsheet Converters, Text Converters, E-mail Conversion, Document Conversion, PDF Conversion and more! \$
CSV Converter \$

IMPORTING
Import SQL Into Excel-SQL Tester \$
Import Excel Into Access \$

CONDITIONAL FORMATTING
Conditional Formatting
More Than 3 Conditional Formats
Conditional Format Fonts for greater than 3

CUSTOM FORMATS
Custom Formats
Excel see a cells format as having four Sections. These are, from left to right: Positives;Negatives;Zeros;Text.

To hide zeros cell-by-cell use a Custom Number Format like 0.00;-0.00; where 0.00 is desired format for non zeros. Note the use of -0.00 for negatives.

To hide zeros on the Workbook level go to Tools>Options>View - Zero Values.

Dec 15, 2008 | Microsoft Windows XP Home Edition

### Setting a Formula

You should use the formula COUNT (Cell1, Cell2), please replace Cell1 and Cell2 for the range of your cells in Excell. You could use too the formula COUNT.IF(Cell1,Cell2,Criterion), Cell1 and Cell2 is the range of cells when can exist an entry.
Example The final formula is like:
COUNT(A1:A5)/COUNT.IF(A1:A5,"=x")*100

Nov 24, 2008 | Microsoft Office 2003 Basic Edition...

### Need a formula for excel

select CONDITIONAL FORMATING in Format

select FORMULA IS , CELL VALUE = > < (condition)

after this select Format

font style , COLOR

SEE IT WILL WORK CHANGE OF COLOURS ........

Oct 10, 2008 | Microsoft Excel for PC

THERE MAY BE ERROR IN OFFICE INSTALLATION SO PLZ UNINSTALL YOUR OFFICE AND REINSTALL THE OFFICE

Mar 02, 2008 | Microsoft Windows XP Home Edition

### Conditional Formating

Use conditional formatting for the coloumn of student use Option " Formula Is" - In this write cell address of Marks e.g.c5 Then write =\$c5>80 then click format and format the pattern

Oct 03, 2007 | Microsoft Office Standard for PC

## Open Questions:

#### Related Topics:

95 people viewed this question

Level 3 Expert

Level 3 Expert