display

Good Day I am trying to find a way to type and only indicate the number of years and months in one cell. This format must also then be used to calculate and end date for a contract term. I would like to be able to display the cell value as 9 y 11 m or 2 y 3 m etc... This must then be added to...

Dear professionals, when a cell result in ANY positive value, example such as "10%", I would like the very same cell to display as "Underestimate 10%" on the other hand a cell result in ANY negative value, such as "-5%", i would like the very same cell to display as "Overestimate 5%" Please...

Hello, I'm lost (per usual) and have searched long enough that I'm starting to go insane so my next step is to post my questions here. Our sales team is needing/wanting a leader board to not only monitor and display the individual sales but also the team (groups of 4 people) sales. So every...

I have a long list of stock option strikes, 130 in all. When the stock price moves up or down beyond the number of rows I can see in my display, is there a way to automatically center the display based on a specific cell (at-the-money strike)?

I must, after pasting a long list of patient names, truncate to display only the first two letters of the last name, for privacy. Beethoven, Ludwig V must become Be., Ludwig V Doe, Jane X must become Do., Jane X I've been using this: =(LEFT(D66,2)&"."&","&(RIGHT(<wbr style="color: rgb(34...

I have a column in excel that has been formatted to display a progress bar based on the value in the cell 0 - 100. I did this by going to: Home > Conditional formatting > Data bars > More Rules: Then I select, Format Style: 'DataBar' / Type(min/max) 'Number' / Min Value: 0 Max Value:100 This...

Hello, This seems like a simple cell format issue but everything I have tried has not worked for me. I am using Office 365, I have 6 cells merged that display the result of an Index/match formula. This cell is formatted as a fraction but will only display a decimal number. I would like it to...

I have a userform that is to large on screens that are 1920*1080 or below, how can I check users resolution and if it is smaller or 1920*1080 I want to display the small userform? If it is 1920*1080 or bigger I want to display the normal userform?

I currently have a formula telling me the the date in which an animal reaches 16 months in age or 30 months in age, depending on whether they are a "B" or an "ST". =IF(E3="B",EDATE(C3,16),IF(E3="ST",EDATE(C3,30))) Would it be possible to add a function that would display a dash "-" if the B...

Alright guys, I'm pretty new to VBA and am working on a fairly simple userform to display data from multiple sheets in one place. I need help with one aspect, I need to convert days of the week to actual dates. The trick is I need to find the next available day of the week based on today's...

Good morning! I have a layout that looks like this: For one criteria, I would like to: Display QUAL if the date is in the current or previous month. Display NC/QUAL if the date is before the previous month. Display UNQUAL if the date is blank. For a different criteria, I would like to...

First, a Disclaimer. I am absolutely 100% new to working with Excel. This exercise I am having an issue with is my first time playing with cell formatting and formulas. What I want to do, which sounds simple in my head, is input an amount of time into a cell, but have it display as its decimal...

Hi All, Noob here :) Need help with IF function. I have Data from Cell A2 - K2 Cell's B2 to K2 displayes "Yes" or "No" it compares previous week roster to current week roster I wan't to display Data in A2 using IF if there was changes from previous week to current week. I was thinking of...

Hi, Could you please help with VBA code for below condition If the date in Column “I” is between 01/01/2017 to 12/31/2017 and Column “H” is >=0.50 Column A should display as A else D

I have a user form that provides the end user with a simplified display of information, I need to populate a text box with the word 'Blocked' if the value in the workbook = 0

Hi folks, I am relatively new to Excel functions, but have set up a shared sheet in Google docs for my friends and I to do an online auction for our Fantasy Football draft in real time. I have each of our names in a separate column across row 11, and a blank cell below each name in row 12 for...

Hi I have the following problem. I am trying to automate a time-sheet but I am having a problem converting .30hrs to 0.50hrs. For example: C4 I have the start time 08.00 D4 I have the finish time 08.30 E4 I have D4-C4 which equals 0.30 C4 I have the start time 08.00 D4 I have the finish...

=IF(H2<TODAY()-14,"Old",IF(H2<TODAY()-7,"Last Week", "This Week")) I found this formula and my only issue is that I want the week to start from Monday to Sunday.. for last week and this week.

=IF(I2="Weld Rod","A",IF(I2="Flame Spray Poweders","B",IF(I2="Special Applicate Coatings","C",IF(I2="Liquid Pen Materials","D",IF(I2="Assorted Glues","E",IF(I2="Powders Blasting MTRL","F",IF(I2="Materials","G"))))))) If I2 is blank the result is: FALSE. How do I get it to display a blank cell...

We'll start there in the subject. I have been racking my brains. In a row, you have a persons name. I want next to that name how many GREEN cells are on that row that he is on. He is on A4. The data range for his name is from L4 to NL4. Come cells have an orange, others yellow. Just want the...