Forum Discussion
Solved
Excel Formula Help - Add specific value based on cell value
Hello all, Would appreciate some help with building a formula. I've provided a more basic example of what I need below. I want to complete Column C, by adding a certain value to Column B, depend...
You may simply try this...
In C1
=B1+IF(A1="Up",50,IF(A1="Down",100,0))and then copy it down.
Subodh_Tiwari_sktneerThis worked perfectly, thank you.
You're welcome SeanM365! Glad it worked as desired.