Forum Discussion
Egnilkuk
Apr 24, 2023Copper Contributor
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.
- Yes, thank you - brilliant - you are a genius. And a very short formula.
2 Replies
Sort By
- EgnilkukCopper ContributorYes, thank you - brilliant - you are a genius. And a very short formula.