h12

Hello Everyone. I am having a very difficult time with an If Statement. It has been a very long time since I have done this so I am a bit rusty. The calculation consists of the following, Cell H12 has the calculation/function, Cell C12 needs to be greater than Zero, and cell M5 needs to also be...

I have descending numbers from A1-A21 I have a value in D5 I would like to conditional format column A to highlight red the value that's closest to D5 by a matter of rounding down.

I have a formula in K12 as seen below =IFERROR(VLOOKUP(F12,Table!A:W,23,FALSE),"") I want to modify it to look at values in both F12 and H12, so I created the following =IFERROR(VLOOKUP(F12&H12,Table!A:W,23,FALSE),"") Even though the formula did not error out (syntax must be correct), I am not...

Hi there, Having a brain freeze and cant get this to work and not sure where wrong although it does look untidy...

Hello, I have the following formular: =FIND("*",H12) This searches for the first * character in cell H12, and returns the character position of that *. And it works great! However, I have a condition where sometimes H12 doesnt contain any * characters, and has a hash (#) character instead...

Hello, How would I alter the following code so that I could get the sum of F12:H12, rather than just the exact cell H12? destcell1.Offset(r, 0).Value = GetCellValue(folderPath & fileName, "Forecast", "H12") Many thanks.