b14

Hi, I have the current formula in cell M14: =-IF(SUM($M$8>B14),SUM($M$8-B14),0) However, I only want it to work if there is a value in cell B14 If cell B14 is blank I want cell M14 to show 00:00 (Its a time formula). Can anyone help? Thanks, Tim

I am working on a form where if B14 is populated with a Person's Name C22 populates their contact info... (which is easily done) However, I am looking to have if B14 is blank (no name populated) but B20 has a name the same C22 populates the same contact info... Is there a formula or work around...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> Hello everyone Just need a bit of help with the if function What I want to do is if b14 cell contains a number then i would like to but the current date + 365 days into J14...

I have a code to automatically enter the date if any data is entered into cells B14 to B100 Private Sub Worksheet_change(ByVal Target As Excel.Range) If (Target.Count = 1) And _ (Not Intersect(Target, [B14:B10000]) Is Nothing) Then _ Target.Offset(0, -1) = Date End Sub but...

I have a large client product ID grid I am working with where I am trying to develop a formula that will pick up the column header values (product ID) if an X is present in the cell. The formula is in the Codes column, below is a sample of what I am working with but there are many product codes...

Hello, I am looking for some help, I have a spreadsheet that has 8 tabs, 5 of those I was looking to rename based on cell B14 in that sheet. I was trying something like this but I can't figure out how to have it select the correct B14 value and change only those tabs I need to rename. The...

Hi All, I have set conditional formatting to cells on my worksheet that detect if the same value appears. IE: If cell B6 value is "V10" and cell B14 value is "V10" then cell B14 color changes and text turns bold. Formatting rule = "Format only cells that contain" - This is in cell B14 Cell B23...

hi, I want to make an inventory list. what i gave right now is in Cell A1,A2, A3 etc i have the item, cells B1, B2, B3 etc if for the amount i have of that item, and Cells C1, C2, C3 etc are for its location. i just type those in as i see them, but i want the final list to be listed...