Forum Discussion

Wendy Coyle's avatar
Wendy Coyle
Copper Contributor
Apr 19, 2018
Solved

Excel formula Help

I am getting a false return in cell K11 and I would like some help to add the correct formula please.   It only reads false when the figure in G6 is greater than 17.   The red formulas are only bec...
Formulas & Functions
Need Help
  • Damien_Rosario's avatar
    Damien_Rosario
    Apr 20, 2018

    Hi Wendy

     

    Hopefully I am understanding the calculations right, but I've altered the formulas in your workbook significantly to reflect the scenario you have provided.

     

    Have a play with the attached worksheet and see if this does the trick?

     

    You just have to enter in the numbers in G5 and G6 and the formulas will calculate the rest!

     

    Please let me know how you go?

     

    Cheers

    Damien

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Apr 20, 2018

Hi Wendy

 

Hopefully I am understanding the calculations right, but I've altered the formulas in your workbook significantly to reflect the scenario you have provided.

 

Have a play with the attached worksheet and see if this does the trick?

 

You just have to enter in the numbers in G5 and G6 and the formulas will calculate the rest!

 

Please let me know how you go?

 

Cheers

Damien

  • Wendy Coyle's avatar
    Wendy Coyle
    Copper Contributor
    Apr 20, 2018

    Wooooo Hoooooo !!! Thank you soooo much Damien.  I am so pleased.  You have saved us one big headache on payday !!!

    • Damien_Rosario's avatar
      Damien_Rosario
      Silver Contributor
      Apr 20, 2018
      Glad to help!

      All the best with your pay day!

      Cheers
      Damien

Resources