When I enable formulas in excel, prices are not displayed on the client side

General
1

How can I enable formulas and still be able to display the calculated prices on the client side

2

Hi Joshua,

I would like to ask for more details here.

  1. Have you turned on Sheet Formulas for your store?
  2. If yes and its still not working, can you please share a screenshot of the formula you are trying to use?
  3. Are you adding any currency symbols to the price?

Regards,
Aslam

3

The problem happens immediately after turning on the formula switch. Yes the switch is on.

I did not use a current symbols only numbers.

I added columns to the left of the price column so the final total would be in the price column. I wanted to convert Japanese Yen to USD then multiply USD by 1.3