Help

Multiplying two fields

Topic Labels: Formulas
Solved
Jump to Solution
508 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Christa_Patton1
5 - Automation Enthusiast
5 - Automation Enthusiast

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.  

Christa_Patton1_0-1695842314149.png

I get #ERROR 

Thank you for the help.  

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @Christa_Patton1

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

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @Christa_Patton1

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

Christa_Patton1
5 - Automation Enthusiast
5 - Automation Enthusiast

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