Forum Discussion

Equiries null's avatar
Equiries null
Copper Contributor
Mar 24, 2018

Excel formula question

Hi All

I am struggling with how to write the formula in an excel spread sheet to say

If the sum of box Y is greater than 194 multiply by 1%

 

What should I type in, Please.

 

Thank you

Tony

1 Reply

  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor

    Hi,

     

    Welcome to the Microsoft Excel Community

     

    Please let us know what to multiply by 1%?

    Is it the sum of Y or something else?

     

    And what is the box Y?

    Do you mean the column Y?