Skip to main content
Solved

Multiplying two fields

  • September 27, 2023
  • 2 replies
  • 60 views

Forum|alt.badge.img+3

Hi, I've looked up my situation to see what the problem is and I'm still getting an error message.  I want to multiply two fields to get a total.  Qty field and Cost field.  Here is my formula.  

I get #ERROR 

Thank you for the help.  

Best answer by Sho

Hi @Christa_Patton1

One possible case is when either field is a string.
What does each field look like?

2 replies

Forum|alt.badge.img+21
  • Inspiring
  • 560 replies
  • Answer
  • September 28, 2023

Hi @Christa_Patton1

One possible case is when either field is a string.
What does each field look like?


Forum|alt.badge.img+3
  • Author
  • New Participant
  • 4 replies
  • September 28, 2023

Hi, @Sho Your question solved it for me.  I see I didn't have the QTY as a number but as text.  Thank you