Multiplying two fields

Christa_Patton1 · ‎Sep 27, 2023

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.

Sho · ‎Sep 28, 2023

Hi @Christa_Patton1、

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

See Solution in Thread

Sho · ‎Sep 28, 2023

Hi @Christa_Patton1、

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

Christa_Patton1 · ‎Sep 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