Can Someone help me with a formula?

Question

=IF(Raw!P2=320,"Raw!Q2-C",Raw!Q2)&nbsp;It is not adding the -C to my end result.For exampleI want PRE-CBut the formula returns PRE

hansvogelaar · Answer

Anonymous126&nbsp;
Perhaps
&nbsp;
=Raw!Q2&amp;IF(Raw!P2=320,"-C","")

anonymous126 · Answer

Thanks for the help, but the formula still only returnedPREinstead ofPRE-C

hansvogelaar · Answer

Anonymous126&nbsp;
Perhaps RAW!P2 contains 320 as a text string instead of as a number?

anonymous126 · Answer

Thank you, it worked

Forum Discussion