nested formula

Hi all I’ve been trying to do a formula to pull information fromthis table but I keep getting an error. My formula is: =if(=COUNTIFS('25.2.19'!A:A,A4,'25.2.19'!$D:$D, $D$3, '25.2.19'!$F:$F, “Best offer”), <today)< font=""></today)<> But I keep getting an error. What I’m trying to do is a...

I am hoping somebody can suggest a simplified version of what I currently have. I am tracking time spent on a project by other team members and have an extremely over complicated way of working out the costs. I created a user form for inputting the hours to make it simpler for the team and...

Hello Mr. Excel experts! I'm in need of help to manipulate a data report that populates the entire information into one cell ("Text to columns" does not work unless there's some amazing trick I don't know how to use). This is a credit card financial statement data. Below is a small...

Hi all, I have a brilliant formula that I need assistance updating. It concatenates a range of cells and will not include blank cells. It will also not include training commas when there are blank cells. I need help adjusting the formula so that it will not include "apparently blank cells"...

Hi All I am hoping that somebody can help me with a formula that I am having a little difficulty with. I am sure that I can not see the answer for looking!! I have this formula "=IF($A5="Spare","",(IFERROR(IF(INDEX('All Holiday'!$D$3:$OR$536,MATCH('Core Rotas'!$B5,'All...

I'm not entirely sure how to nest a string of IF functions with a LEFT function. My IF function is as follows (located in cell W2): =IF(I2<>0,I2&", ", "")&IF(J2<>0,J2&", ", "")&IF(K2<>0,K2&", ", "")&IF(L2<>0,L2&", ", "")&IF(M2<>0,M2&", ", "")&IF(N2<>0,N2&", ", "")&IF(O2<>0,O2&", "...

Hiya! :) I am trying to find a way to get the following info into the IF formula: If "Sheet1!"C1=TODAY()-1 then I554 needs to be divided by 15 if not then it needs to be blank. I am trying variations of: =IF("Sheet1!F3"=TODAY()-1, "(I554/15)", "") But it doesn't seem to be working, and just...

Hello everyone, I am rather new here posting but this forum has anonymously helped me solve some of my Excel struggles. So let me try to simplify and explain my current issue i do not manage to find a solution for. I have an Excel table (1,000+ rows) from 2012 which is my basic starting...

A1 = PVT =IF(A1=_OFF,"Yes","No") The Defined Name of "_OFF" list officer ranks and PVT would not be one of them so the result should be NO. However, this formula doesn't work it returns a #VALUE! error. I was trying to avoid using a VLOOKUP statement for this to keep my formula a little...

Please help. I have been researching and have been unable to find the correct solution. Situation: Column A has 1000's of qualitative survey responses. I would like to label / categorize the survey responses in a corresponding cell. For example: If Cell A1 contains: "shirt","pants","hat"...

4 columns (AR, AS, BD & BE) contains either 0 or 1. Output (column CA) is required based on combination/(s). If AR35=1 AS35=1 BD35=1 BE35=0 Then CA35 should give 1 AR35=0 AS35=1 BD35=1 BE35=0 Then CA35 should give 2 AR35=0 AS35=1 BD35=1 BE35=0 Then CA35 should give 3 AR35=1 AS35=1 BD35=1...

I'm pulling my hair out trying to figure this one out. I have a fake mock-up spreadsheet but the forum will not allow me to post attachments. I am trying to do a nested IF/AND formula that will give me the EXACT name in a specific cell on a different worksheet. Example: "If the obligation...

Please help in excel formula. I want find numbers repetition (double and triple numbers hit/win) in historic lottery list.

<colgroup><col width="64" span="9" class="aab" style="width: 48pt;"></colgroup><tbody> DRAW DATE BALL #1 BALL #2 BALL #3 BALL #4 BALL #5 ODDS EVEN 6/8/2013 33 51 28 3 37 4 1 6/8/2013 8 17 50 40 44 1 4 6/8/2013 48 5 25 16 56 2 3 TOTAL 7 8 -- removed inline image --- <tbody>...

<tbody> RANGE WB # # Win % WIN RANGE 0.25 0.5 0.75 1 1.25 1.5 1.75 2 2.25 2.5 2.75 3 3.25 3.5 3.75 4 1 10 1.67 0.25 2 11 1.83 0.5 3 11 1.83 0.75 4 12 2 1...

:confused:Hi I fully admit to being self taught novice in all aspects of excel and have limited knowledge of its full potential. I have just joined Mr Excel as I am working on a Calculator for my wife. It currently has me completely stumped as to how I can do what I want to get done. I am...

Hi, I've got another formula which doesn't seem to be working. I want it to return one result if both 2 conditions are met, a different result if both another 2 conditions are met and then another result if they are both false. Here's my attempt: =IF(AND(M5="CAFA 1-Initial Assessment (concurrent...

I'm having an issue trying to get the following formula to return N/A instead of #VALUE! =IF($K8>$F$5,(TODAY()-$K8)*($O8*0.2739726%),(TODAY()-$F$5)*($O8*0.2739726%)) Can anyone help me to do this? I can't get my head around it at all and have a deadline looming. Any help would be really...

It seems like it's impossible, but I could just be missing a nested function somewhere...really I have no clue how to get to what I'm looking for. I'm trying to use a formula that if the row matches a series of criteria, will take the sum of a formula applied to the matching row (the formula...

Hi Guys & Gurls thanks for reading this, I'm having a few issues with a current spreadsheet I'm working on, its designed to track inspection frequencies, it was all working fine until the client decided they wanted to track two different industry requirements :-( its set out like this Cell...