SOLVED
Home

IF formula help

%3CLINGO-SUB%20id%3D%22lingo-sub-552702%22%20slang%3D%22en-US%22%3EIF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-552702%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20write%20a%20formula%2C%20that%20will%20automatically%20fill%20if%20Cell%20C34%20is%20greater%20than%200%20and%20fill%20in%20a%20few%20other%20cells.%3C%2FP%3E%3CP%3EIn%20the%20attachment%2C%20if%20Cell34%20is%20greater%20than%200%2C%20I%20would%20like%20for%20Cell%20B35%20to%20populate%20the%20following%20month%20and%20Cell%20C35%20to%20populate%20the%20corresponding%20Available%20Work%20Days%20(Column%20H).%20Then%20if%20Cell%20C36%20is%20greater%20than%200%2C%20have%20Cell%20B39%20populate%20with%20the%20following%20month%2C%20and%20then%20have%20CellC40%20populate%20the%20corresponding%26nbsp%3BAvailable%20Work%20Days%20(Column%20H).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-552702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-555861%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-555861%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F339153%22%20target%3D%22_blank%22%3E%40drt_80%3C%2FA%3E%26nbsp%3B%2C%20you%20can%20use%20these%20formulas.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20cell%20B35%26nbsp%3B%20(you%20had%20manually%20entered%20the%2031st%20September%2C%20but%20September%20has%20only%2030%20days)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(C34%26gt%3B0%2CEOMONTH(B34%2C1)%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ein%20cell%20C35%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(B35%26lt%3B%26gt%3B%22%22%2CVLOOKUP(B35%2C%24A%2417%3A%24H%2432%2C8%2CFALSE)%2C0)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ein%20cell%20B39%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(C36%26gt%3B0%2CEOMONTH(B35%2C1)%2C%22%22)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ein%20cell%20C40%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DIF(B39%26lt%3B%26gt%3B%22%22%2CVLOOKUP(B39%2C%24A%2417%3A%24H%2432%2C8%2CFALSE)%2C0)%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-558365%22%20slang%3D%22en-US%22%3ERe%3A%20IF%20formula%20help%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-558365%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F7724%22%20target%3D%22_blank%22%3E%40Ingeborg%20Hawighorst%3C%2FA%3E%26nbsp%3B%20Perfect%2C%20Thank%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
drt_80
Occasional Contributor

I am trying to write a formula, that will automatically fill if Cell C34 is greater than 0 and fill in a few other cells.

In the attachment, if Cell34 is greater than 0, I would like for Cell B35 to populate the following month and Cell C35 to populate the corresponding Available Work Days (Column H). Then if Cell C36 is greater than 0, have Cell B39 populate with the following month, and then have CellC40 populate the corresponding Available Work Days (Column H).

 

Is this possible?

 

Thanks in advance.

2 Replies
Solution

@drt_80 , you can use these formulas.

 

In cell B35  (you had manually entered the 31st September, but September has only 30 days)

 

=IF(C34>0,EOMONTH(B34,1),"")

 

in cell C35

 

=IF(B35<>"",VLOOKUP(B35,$A$17:$H$32,8,FALSE),0)

 

in cell B39

 

=IF(C36>0,EOMONTH(B35,1),"")

 

in cell C40

 

=IF(B39<>"",VLOOKUP(B39,$A$17:$H$32,8,FALSE),0)

 

 

 

@Ingeborg Hawighorst  Perfect, Thank you!

Related Conversations