Forum Discussion

Copper Contributor

Oct 27, 2022

Can Someone help me with a formula?

=IF(Raw!P2=320,"Raw!Q2-C",Raw!Q2) It is not adding the -C to my end result. For example I want PRE-C But the formula returns PRE

Formulas and Functions

MVP

Oct 27, 2022

Perhaps

=Raw!Q2&IF(Raw!P2=320,"-C","")

Anonymous126
Copper Contributor
Oct 28, 2022
Thanks for the help, but the formula still only returned
PRE
instead of
PRE-C
- HansVogelaar
  MVP
  Oct 28, 2022
  Anonymous126
  
  Perhaps RAW!P2 contains 320 as a text string instead of as a number?
  - Anonymous126
    Copper Contributor
    Oct 28, 2022
    Thank you, it worked