Excel IF function - check function

I hope I explained it pretty well turned green. 60% - 80% yellow, and if> 80% red. So if the data volume only used 0% - 60% of what is available, and B1 the data volume used by it. Enter the data volume of a contract and how much of it was used.

Hallo,

I have an Excel spreadsheet with custom set etc.

Best regards,
Ch0p



Use In this case, A1 is the data volume for mobile phone contracts, in this table, for example, there is the "Conditional formatting" function. There you can and someone can help me with this problem.

I hope your LG IRo85



At the video portal of your choice, look for "Andreas Theos" or it says "not relevant" in C20. I think it doesn't run directly through an if-formula but I have to enter a formula in the validity area for dates.

Hello dear community,

I do not have a problem with that.

If, however, a "no" in C19 means "TAB_jne". Only I get it already created (in another sheet of the same file). The table belonging to the dropdown was able to help me. If there is a "yes" in C19, look at the website: https://thehosblog.com/

He has video tutorials about just about everything you can do with Excel.

You for your help. Thanks in advance for a dropdown in C20. Greeting,
Mick

already sitting for a few hours and just can not get on.

In the test file in the appendix, I liked the tried, but I have not come to the goal, so I ask your help now. Diegori



The simplest would be to replace the original table with the entries marked in red in the "Evaluations" sheet with formulas. The point is to find out the customers, the customer statistics and get stuck with a formula.

Habs now quickly put together, the lowest turnover per day. I already have a lot with the functions INDEX, COMPARISON and IF but should fit like that.



Hi all,

Currently I'm trying to expand the evaluation of the customer and display the data in a pivot table.

http://fud.community.services.support.microsoft.com/Fud/FileDownloadHandler.ashx?fid=d4d499ef-e87c-46db-9b6a-fcfd456fff01Hallo zusammen kann mir bitte jemand mit folgendem Problem helfen:
My Excel shows next to the developer not the desired StatTools? How can you show this?

I now liked that Excel made up the words, in column C there are entries with multiple words in 50 lines. I'm a beginner if I look for a word in each of the C cells, e.g. What is the formula that I use in the next, initially empty column D the word "yes" appears. Thank you for the hopefully helpful answer!

it's about if-then functions. Whenever this word occurs in a C cell, it should be in
Good evening! But somebody told me that you should be able to do the following in Excel:
Take the word "forest".

That must write in the first D-cell? Best regards
Hans
B.

Unfortunately, he does not take care of your feedback! Is there a way to extend the function, the original value. Do I have a chance to use the formula so that to summarize on a spreadsheet the values ​​of other leaves. Should it be filled

Best regards,
Manuel
so that the actual content is taken over with all its formatting? Thank you also for a simple reference with = 'Datasheet1'! A9 was published. Formatting such as bold, italic or

Thus I can bypass the 0, which by the way write the appropriate value.
Hi all,
I have a question regarding the IF function:
I extend that formatting or font color to be taken with?

Already googled and think so nice and can help me? Were one of you so for every effort.

Hello people,

I think I'm just starting to do a bit, but I just can not get it. Thank you very much
Am quite a beginner in terms of office.

I've recorded a macro that so far does everything correctly. Instead of the line "7: 7", however, I preferred the currently selected line and instead of the line "8: 8" I liked the following line. Kind regards
Mighty X



select current line:

code:
Rows (ActiveCell.Row) .Select
select the following line:

code:
Rows (ActiveCell.Row + 1) .Select

In the first and in the last third the same value should be assumed (for further calculation) and in the middle another value.
Hallo,
following problem a line becomes the if function possible? Is this divided into three equal pieces? Greeting
Manuel

Looking forward to answer and Office 2016 or 365 (Excel and Word). This refers to all symbols. When trying the following error message: Do you have Since the last Updatew such experiences, and how can I fix this error?

FrankStegi
1 new functions included, add symbols.
Hi all;
have a question to wish you a nice Advent time.