formula needed to report value based on value in another column.

[RodneyW]

I need a formula for R2 that I can drag down to R3, etc.

R2 needs to look at Q2, which will either have a “B” or an “O” if Q2=B, then R2 should report the value inP2. If Q2=O then R2 should report thevalue of O2+P2.

Thanks in advance for the help

 

[Fluff]

How about
=IF(Q2="","",IF(Q2="B",P2,O2+P2))

 

[RodneyW]

Needed a minor tweak but this worked:=IF(Q10="","",IF(Q10="O",P10,O10+P10)) Thanks for the help

 

[Fluff]

You're welcome & thanks for the feedback