Forum Discussion

Egnilkuk's avatar
Egnilkuk
Copper Contributor
Apr 24, 2023
Solved

Result of value in one cell to treat a value in another cell.

Hi.

I need a formula to do the following to a value in another cell. Hope some one can give me a single one line formula.

Cell B2 - can have a value of less than 3 to a value >5.

What I want to happen:

Cell C2 is the resulting value from the calculation - so formula goes in C2.

If B2 less than 3 or =3 then add 3% to value of C1 (C1 would be any value)

If B2 =3 or >3 but <5 then use value in B2 to add as percentage to value in C1

If B2 =5 or >5 then add 5% to the value of C1.

Hope I have explained it clearly.

 

  • Egnilkuk's avatar
    Egnilkuk
    Apr 24, 2023
    Yes, thank you - brilliant - you are a genius. And a very short formula.

Resources