Question about Computers & Internet

1 Answer

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)))

×

1 Answer

  • 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
  • 133 Answers

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

Posted on Mar 15, 2008

  • Leonard Muvai
    Leonard Muvai Mar 18, 2008

    No thats the only way u can go around it

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

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).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

2 Answers

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

1 Answer

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

1 Answer

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"

rootmailsd.jpg

Jun 23, 2011 | Microsoft Excel for PC

1 Answer

What is formula new excell


I certainly can't take the time to explain v lookup to you in this forum, but I can direct you to several sites that you can familiarize yourself with it. It's going to take you time to to understand it.

http://spreadsheets.about.com/b/2008/03/17/excel-vlookup-3.htm

http://spreadsheets.about.com/od/excelfunctions/ss/vlookup.htm

http://www.techonthenet.com/excel/formulas/vlookup.php

Jun 21, 2009 | Microsoft Computers & Internet

1 Answer

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

1 Answer

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...

1 Answer

If statement that will change cell color in excel


conditional formatting is alright.

you just have to remove the $ signs in the cell reference when you set a condition.

then, copy-paste

Nov 20, 2008 | Microsoft Excel for PC

1 Answer

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

1 Answer

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

Not finding what you are looking for?
Computers & Internet Logo

Related Topics:

93 people viewed this question

Ask a Question

Usually answered in minutes!

Top Computers & Internet Experts

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

kakima

Level 3 Expert

98765 Answers

David Payne
David Payne

Level 3 Expert

14065 Answers

Are you a Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...