remain

Good morning, I am trying to nest RoundUp Statement within an IF statement for a decimal place. For example if the value is 20.30 I would like it to read 20. If it is 20.50 it can remain the same. Your help is much appreciated.

Fellas, I have 365 daily reports that I have to go thru and change Total on every report and it will be time consuming which I need help please. My report is as follows: Column A:BC (55 lines) and I need to change only the flowing: I only need assistance able to copy and paste the values only...

Fellas, I have 365 daily reports that I have to go thru and change Total on every report and it will be time consuming which I need help please. My report is as follows: Column A:BC (55 lines) and I need to change only the flowing: I only need assistance able to copy and paste the values only...

Hi All, I have a MID formula that returns a two digit number I then want to use as a reference in a lookup. Referring to the cell containing the formula gives me a #N/A error, but if I overtype the formula with the value the lookup works, so I just need to know how to tell the lookup how to use...

I have two userform (Userform A - ShowModal=True & Userform B - ShowModal=False). When I minimize A, B appears. When I close B, A also closes. I want A to remain showing. How can i make B remain open when I close A. (Confused...my apologies)

I'm an Excel novice, so I appreciate any help anyone can provide on this. Here's the situation: 1. I have a cell on a sheet that will be either remain empty or be populated with text, depending upon the value of another cell. Let's say the text that'll appear is "Opp" 2. If the text "Opp"...

Hello, in sheet 2 cells A3:A302 I have numbers ( 60001 to 60300) , which should remain untouched. when I click on A3 sheet 2 it should direct me to sheet 3 . and when clicking on Sheet 2 A4 it would take to sheet 4 and so on. clicking on Sheet 2 A5 takes me to sheet 5 clicking on Sheet 2 A6...

A1 = 2 B2 = 5 C3 = 7 C3 is the sum of A1:B2. If I were to delete the values in A1 and/or B2 what formula is needed to "keep" or retain C3 as 7. Last calculated value to remain active. Thanks

Hi I'm trying to concatenate two columns if one of the columns is not -1 and I'm running into some difficulty. I came up with this formula but it's not being accepted - =IF(AA<>-1,CONCATENATE(A2,AA2),-1)) If column AA is -1, I'd like the concatenate column to remain -1 but if it's not -1, I'd...

Hi, I need a formula that if H4 is blank,J4,L4 and N4 remain blank but if H4 has a number then J4= H4-H3. Thanks

Hi All, New to the Forum so Hello to everyone. I am looking for a formula or formatting condition that will add 0.2 to a cell that ends in .80 to .99 but will not change if its below .80. For example if a cell contains 26.89 I want it to show 27.09 and if it shows 17.69 I want it to remain the...

Hi all, I am looking o use the traffic light system to show any dates in a cell the exceed the current date by 1day, 2 days and 3 days, but if no date just remain blank Starting in K16 thru K512 I was trying =WEEKDAY(TODAY(),1)>1 but cannot seem to get this working correctly Thanks for any help

Hello, I have a formula that links a cell from another WB. The formula works fine but when I drag it down the column in order to link other cells it doesn't copy correctly. It actually copies identical without adding the next row as a reference. I know by placing a "$" in front of either letter...

Hi Gurus, I've been trying and failing for too long at this so i'm here for some help. I'm making a training matrix that uses conditional formatting to alert me when training is about to and has expired. So for example, on 01/01/18 Mr. Smith took abrasive wheels training. The training will...

Greetings form a newbie Need help with this in Excel 2010 (please, please, please) =IF(COUNTIF(C6:C8,"N"),"N","Y") Cell C9 will return a N value if N is selected anywhere between C6 and C8. The problem is C9 returns a Y value if C6 to C8 are all blank. Ideally I want C9 to remain blank...

For example, I have the cells in Row 1, Columns A, B, C, and D as 1" by 1" . What I am looking for is to have the cells in Row 1, Columns A, B, C, and D bet set as 1" by 1 but the cells in Row 1 Columns G and H to remain the default Excel size. Can this be done?

I'm new to excel I am using this formula =IF(OR(J7<5, J7>5), J7, 5) If J7 is less than 5, I want it to remain J7 If J7 is greater than 5, I want it to remain 5

Hi there, I posted a similar question a few years ago which proved successful but cannot find the macro script so will post again. I have multiple rows of data which has been taken from a completed pdf and have been merged into a spreadsheet as a csv. I have saved the spreadsheet as a .xslm...

I am New to the Forum. On the Bottom Right of Table, I am dragging the corner up to resize the table numbers of rows because of unused rows in table But all the the Table Format/Style remain on spreadsheet Also, formulas from cell table remain on spreadsheet too. I need to manually clean the...

I am running a report where I want the cell to remain blank, if the result is "0". for example, I have a list of clients in column A. List of months in A-M. Their billings are in the cells. When calculating their YTD, if their total was zero, I want the cell to remain empty, with no number...