Forum Discussion

Brass Contributor

Nov 18, 2019

Solved

A formula

I have a table 1 with 4 columns, Column 1 = housing, column 2=projected cost, column 3=actual cost, column 4= difference. For each column I would like to use the formula =subtotal(109, [projected co...

Formulas and Functions

wjallen14
Nov 19, 2019
Wyn Hopkinsyes it help greatly. for example pf my next question I have a sheet that December 2019 on and now January is coming so my next sheet marked Jan I would like it to say January 2020. This I would like to go on for the next five years. December 2020 would go January 2021 etc.

wjallen14

Brass Contributor

Nov 19, 2019

Wyn Hopkins

can I ask another question, I am trying to write an if statement where I have one sheet 2019 and the next sheet 2020 but I keep getting a value error. the following is the formula that I am using: =IF(TEXT(DATE(INT((Dec!H1-1)/12)+2019,MOD(Dec!H1-1,12)+1,1),"mmm yyyy"),DATE(INT((Jan!H1-1)/12)+2019,MOD(Jan!H1-1,12)+1,1),"NO__"). thank you

Wyn Hopkins

MVP

Nov 19, 2019

Hi

Did my last answer help?

Could attach an example file with your new question

Thanks

wjallen14
Brass Contributor
Nov 19, 2019
Wyn Hopkinsyes it help greatly. for example pf my next question I have a sheet that December 2019 on and now January is coming so my next sheet marked Jan I would like it to say January 2020. This I would like to go on for the next five years. December 2020 would go January 2021 etc.
- Wyn Hopkins
  MVP
  Nov 21, 2019
  Hi, could you start a new thread with the new question. Thanks