formula =and()

Hi all, I have a lot of cells that look like this: Now, what I would like, is to have a formula that returns ONLY the top part of cell A3 I have separated the texts by pressing ALT + ENTER and then typing: Test 1 Test 2 Test 3 instead of Test 1 Test 2 Test 3 Is there a way in which I...

Hi all, 2 questions: 1) I have the following setup: I add new files quarterly to my excel file, so Q1 2021, Q2 2021, Q3 2021, Q4 2021, Q1 2022, Q2 2022 etc. Right now I only have one for each year, but I plan to add many more going forward for 2022- Does anybody have a way in which I can...

Hi I want to make a point-based level system I'll have the data in a table displayed like this: 10 points 30 points 60 points and so on... but in the scoreboard will be displayed like this: level 1: 10/10 points level 2: 20/20 points (10 points from level 1 + 20 points of level 2) level 3...

Hi all, I'm creating a property investment calculator and I'm trying to automate the stamp duty calculation with a formula rather than checking the government site for each and every property analysed. Eg, Cell B2 contains the purchase price, Cell J2 needs to show the TAS Stamp Duty payable on...

:confused:So I am working on this report where I have to calculate the taxes based on the Gross Profit. I had 4 different Gross profit for 4 different Quarters. I was able to do 3 of them but not the 4th. The reason being that is because it wanted the specific thing: Taxes are 20 % of the...

Here is what I wrote but it is not functioning quite right =IF((AND((F3=NOW()-1),C3>=F3)), "1", "0") What I want to happen is if C3's date is equal to or after the value of F3's date I get a value of 1 Examples: If C3 = "Monday, August 01, 2016" and F3 = "Tuesday, August 02,2015" then...

I need help writing a formula. I am trying to make some budgeting sheets in Excel. I have one sheet with a table called MonthlyExpenses, with columns for Date, Categories (includes a drop down list with specific options), and Actual Cost. On another sheet I have a summary sheet which compares...