calcualtion

I did an update last month. I'm now having an issue where sometimes a column of formulas doesn't calculate if the column is formatted as text. It took a little while to figure out that the formatting of the column was the issue. Instead, it will just show me the text of the formula, which...

Hey Team, I know this topic has been covered a lot but I have yet to find a signal formula to handle all of the possible situations. I am trying to convert fraction feet and inches to decimal feet (Or inches whatever is easier). The possible situations include Inches with fractions B3, whole...

Hello, need calculation for below table i have values in column B which need to calculation in below manner to get result for highlighted cell - note highlighted in red value need to come trough formula , text highlighted in white value we don't have, text highlighted in bold total is same...

Greetings, I am somewhat lost how to approach this problem that I have. In essence I want to calculate demands per material for specific date based on the number of projects on that date. for this I have 3 tables Project Consumption Table (showing how much of each material is consumed for each...

I am not excel savy at all but I need help! Depending on if there is a date in the field, I need the results to populate in B3. I got two dates (difference between E9 and B9). But If there were to be a date in B12 (as opposed to B9) and a date in E9, can I get the result to populate in B3? Same...

Hi there, I’m hoping someone can help me with this question. I have a series of formula being used to generate unique reference numbers, finishing with CONCATENATE, as seen in the screencap attached. I am using a simple =IF(H60=””,””,ROW()-2) formula to generate the final four digits of the...

I have a situation like this: In one cell, I split the time ranges over several lines, for example 07: 15-10: 27 10: 35-11: 00 11: 15-12: 27 13: 15-13: 27 14: 15-18: 27 19: 15-20: 27 21: 15-23: 39 I know it would be more logical to have an hourly range divided over several lines, unfortunately I...

I am looking for a way to use the number of working days passed to figure sales pace on a daily basis. I have the formula already to use (total sales) / # of working days passed * # of selling days in the month. I added a helper field for both areas to represent number of days passed, but not...

Okay so apologies if this doesn't make much sense, Mr Excel newbie here... I have a huge problem as I'm trying to automate a report and the report involved holds critical data for daily usage. The problem I'm having is in column A on one of my worksheets (Tails) there is a formula array...

Hello, I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance. =IF(B38<1,0...