Hi All,

In my spreadsheet attached, I have a gift date, based against the UK bank holiday date, I wanted to check if the gift date lands on the bank holiday date, if it does, then in date gift received would then add 2 days to the gift date, if it doesnt then it would just display the gift date. I would need this for every bank holiday in the uk, however as a starting point it would be helpful if anyone could give me some guidance.

TIA

In my spreadsheet attached, I have a gift date, based against the UK bank holiday date, I wanted to check if the gift date lands on the bank holiday date, if it does, then in date gift received would then add 2 days to the gift date, if it doesnt then it would just display the gift date. I would need this for every bank holiday in the uk, however as a starting point it would be helpful if anyone could give me some guidance.

TIA

L8 | B8 | O8 | P8 | R8 |

89 | 85 | 95 | 75 | BUY |

My scenario is simple i want to display text in cell R8 when L8>O8,"BUY",B8>O8,"BUY-F",L8< P8."SELL",B8< P8,"SELL-F".

For this i used function ie =IF(L8>O8,"BUY",IF(B8>O8,"BUY-F",IF(L8< P8."SELL",IF(B8< P8,"SELL-F","")))), Datas in cell L8 & B8,are real time data and in cell O8 &P8 are predefined data (manually feeded or fixed data) when i execute above function it is diplaying "BUY" instead of blank bcz data in L8 is less than O8, but this function is works correctly only when if all cells are have real time data or predefined data, above scenario is an example of one cell i want to apply it to whole sheet pls help me to resolve this issue

Hi All,

I wanted to be able to find the difference between two dates based on whether one criteria is the same as the criteria above it if so calculate the date difference between, if it doesnt then leave it and go to the next. Please find an example of my data set below:

e.g from my data set below - for customer id 1, row 4 would look up row 3 for customer id and because they match, it would calculate the date difference, same for row 3 to row 2, but row 2 doesnt have any data above it, it would automatically throw out a 0 against it.

A B C

Any help would be greatly appreciated.

TIA

]]>I wanted to be able to find the difference between two dates based on whether one criteria is the same as the criteria above it if so calculate the date difference between, if it doesnt then leave it and go to the next. Please find an example of my data set below:

e.g from my data set below - for customer id 1, row 4 would look up row 3 for customer id and because they match, it would calculate the date difference, same for row 3 to row 2, but row 2 doesnt have any data above it, it would automatically throw out a 0 against it.

A B C

Customer ID | Date | Amount |

1 | 01/01/2012 | 20 |

1 | 02/01/2015 | 20 |

1 | 03/01/2016 | 35 |

3 | 12/12/2015 | 65 |

3 | 13/12/2018 | 12 |

5 | 23/01/2005 | 5 |

5 | 15/05/2007 | 14 |

12 | 14/02/2004 | 13 |

12 | 15/02/2006 | 8 |

12 | 16/02/2009 | 16 |

12 | 17/02/2012 | 19 |

13 | 16/05/2013 | 100 |

13 | 17/05/2014 | 120 |

13 | 18/05/2015 | 100 |

Any help would be greatly appreciated.

TIA

Hi Everyone,

can you help me with my workbook? If I select an insurer in N2, I wanted to show the list with the specific insurer, names and comment in M9 to O14, however, looks like my formula is returning just one row.

attached is the workbook.

Thank you.

can you help me with my workbook? If I select an insurer in N2, I wanted to show the list with the specific insurer, names and comment in M9 to O14, however, looks like my formula is returning just one row.

attached is the workbook.

Thank you.

I have a drop down list at I7 which I want to drop data into J7 when an item is selected from the list. For some reason the formulas I tried wont work or I am doing something wrong that I cant see. the specs sheet below in columns A and B are the ones that are for I7. Column A is in the drop down list and Column b is for J7. What I need is when fresh yeast is selected only 1% is entered in J7. The same for the dry instant yeast = .03%

If someone could help I would appreciate it.

Thanks in advance GregT

Hello!

There are products that are identical by name and same by price but the products codes are different.

When seller sells products writes only the name of the product, the quantity and its price, because of the goods are different by code

and same in price it is impossible to determine which product is sold.

I determine the product code by date, price and name, but I can’t take the quantity into account dynamically.

Can you help me with advice how to dynamically change the quantity of a sold product?

Thank You

]]>There are products that are identical by name and same by price but the products codes are different.

When seller sells products writes only the name of the product, the quantity and its price, because of the goods are different by code

and same in price it is impossible to determine which product is sold.

I determine the product code by date, price and name, but I can’t take the quantity into account dynamically.

Can you help me with advice how to dynamically change the quantity of a sold product?

Thank You

Hey everyone!

I have this spreadsheet that track when I get into to work and when I leave. The "Diff" row is where I want to insert a formula that will take the total amount of time that I've worked in the day and subtract 8 and half hours from it. So for example, under "10/16" I want the formula to output -30 or -.5 as the Total hours worked that day was less than 8 and half (8 hours worked that day).

I thought this would be simple but apparently you can't show a negative value in Time format which is fine but when you use a Number format the number is between 0 and .9999 so I can't interpret how many hours or minutes I've worked less or extra in that day.

Feel like this is a simple solution but I'm blanking on this hard for some reason. Can anyone help?

Thanks in advance!

Timesheet.xlsx

I have this spreadsheet that track when I get into to work and when I leave. The "Diff" row is where I want to insert a formula that will take the total amount of time that I've worked in the day and subtract 8 and half hours from it. So for example, under "10/16" I want the formula to output -30 or -.5 as the Total hours worked that day was less than 8 and half (8 hours worked that day).

I thought this would be simple but apparently you can't show a negative value in Time format which is fine but when you use a Number format the number is between 0 and .9999 so I can't interpret how many hours or minutes I've worked less or extra in that day.

Feel like this is a simple solution but I'm blanking on this hard for some reason. Can anyone help?

Thanks in advance!

Timesheet.xlsx

Hi amazing excel formula minds,

I've been trying to extend my current formula to span about 11 different rosters (in another tab titled Roster!), but I havent had much luck extended the below:

=IFERROR(IF($C$7=Roster!$C$2,INDEX(Roster!$C:$C,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$D$2,INDEX(Roster!$D:$D,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$E$2,INDEX(Roster!$E:$E,MATCH(F$10,Roster!$B:$B,0)),""))),"")

Basically just need the top replicated 11 times (each index match is for 1 roster type names go across ie. $C$2, $D$2, $E$2 etc through to $M$2) and roster patterns associated to each roster name go down the list ie. $C:$C, $D:$D, $E:$E etc through to $M:$M, the match codes will remain the same throughout the formula - hope this makes sense.

I usually just copy and paste entire IF(Index, Match) formula to replicate, but I cant quite figure out the end part where the closing parenthesis goes

Any help would be amazing!

Thank you in advance

]]>I've been trying to extend my current formula to span about 11 different rosters (in another tab titled Roster!), but I havent had much luck extended the below:

=IFERROR(IF($C$7=Roster!$C$2,INDEX(Roster!$C:$C,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$D$2,INDEX(Roster!$D:$D,MATCH(F$10,Roster!$B:$B,0)),IF($C$7=Roster!$E$2,INDEX(Roster!$E:$E,MATCH(F$10,Roster!$B:$B,0)),""))),"")

Basically just need the top replicated 11 times (each index match is for 1 roster type names go across ie. $C$2, $D$2, $E$2 etc through to $M$2) and roster patterns associated to each roster name go down the list ie. $C:$C, $D:$D, $E:$E etc through to $M:$M, the match codes will remain the same throughout the formula - hope this makes sense.

I usually just copy and paste entire IF(Index, Match) formula to replicate, but I cant quite figure out the end part where the closing parenthesis goes

Any help would be amazing!

Thank you in advance

Hi,

I'm pretty good with Google Sheets and Excel but I've been trying to get a formula to work for the following situation for a few days now and just can't get it to work - any help would be great.

I have a google form which staff use to enter the following: Name, Branch, Day of the week, Profit and Week number

Once the data has been entered another worksheet in the same spreadsheet collates the information and gives me the total profit for each person each week. However I can only get the formula to display one person (the first person from the responses that matches the Branch and Week) so anyone else working in the same branch that week wont show.

this is the formula I'm using at the moment

=INDEX('Form responses 1'!$A$2:$C$3,MATCH($L$3&B7,'Form responses 1'!$C$2:$C$3&'Form responses 1'!$F$2:$F$3,0),2)

any help would be great

Thanks

Martin

]]>I'm pretty good with Google Sheets and Excel but I've been trying to get a formula to work for the following situation for a few days now and just can't get it to work - any help would be great.

I have a google form which staff use to enter the following: Name, Branch, Day of the week, Profit and Week number

Once the data has been entered another worksheet in the same spreadsheet collates the information and gives me the total profit for each person each week. However I can only get the formula to display one person (the first person from the responses that matches the Branch and Week) so anyone else working in the same branch that week wont show.

this is the formula I'm using at the moment

=INDEX('Form responses 1'!$A$2:$C$3,MATCH($L$3&B7,'Form responses 1'!$C$2:$C$3&'Form responses 1'!$F$2:$F$3,0),2)

any help would be great

Thanks

Martin

Hi,

I have got a task which I cant figure out. I want to build a prediction model if we should buy stocks or not. And by using an external parameter (demand from customer on the whole market in our area which we get daily) I want to predict if the stock price tomorrow goes up or down.

I have columns with:

Daily prices for last 10 months.

The price change per day in %

The price change per day in $

Customer Ratio (The variable Im suppose use to predict with)

I want excel by the end of each day to look at the daily %change and on the customer ratio, and give me a signal if I should "Buy / No buy" TOMORROW (not the same day since it just closed). We always sell after 24 hours if excel doesnt tell us otherwise.

a) Maximize the profit

b) Keep the number of "loss-days" to a minimum (I.e control the risk!)

b) What threshold should be used on the customer ratio? I.e when is it good to buy or not?

c) What should the %-change be?

For example...I want to be able to say:

Okey if the customer ratio is below 4 and the price went up 5$ yesterday, we should buy today.

I CANT FIGURE IT OUT!

I have got a task which I cant figure out. I want to build a prediction model if we should buy stocks or not. And by using an external parameter (demand from customer on the whole market in our area which we get daily) I want to predict if the stock price tomorrow goes up or down.

I have columns with:

Daily prices for last 10 months.

The price change per day in %

The price change per day in $

Customer Ratio (The variable Im suppose use to predict with)

I want excel by the end of each day to look at the daily %change and on the customer ratio, and give me a signal if I should "Buy / No buy" TOMORROW (not the same day since it just closed). We always sell after 24 hours if excel doesnt tell us otherwise.

a) Maximize the profit

b) Keep the number of "loss-days" to a minimum (I.e control the risk!)

b) What threshold should be used on the customer ratio? I.e when is it good to buy or not?

c) What should the %-change be?

For example...I want to be able to say:

Okey if the customer ratio is below 4 and the price went up 5$ yesterday, we should buy today.

I CANT FIGURE IT OUT!

I have a table that has like 15 rows. When I first started the table, I was only using 3 formulas in the row. Now on row 15, I have added 2 more formulas, so there are 5 cells in the row with formulas. However, when I hit tab to start a new row, it only brings down the original 3 formulas, not the new 2 formulas.

I have gone into Options and turned on "Fill formulas in tables to create calculated columns", but it still doesn't work.

This is happening on multiple spreadsheets and I am clueless what to do.

Thanks in advance.

]]>I have gone into Options and turned on "Fill formulas in tables to create calculated columns", but it still doesn't work.

This is happening on multiple spreadsheets and I am clueless what to do.

Thanks in advance.