Pop up menu as text data format problem in multiplication

please provide me formula for this

I work as a multi combination heavy vehicle truck driver. I get paid according to the combination I drive. In my Sheet , I want to apply a formula in Service charges column,

that for combination type column pop up menu

for B double ,services charges = trips kms x .54 $

for semi , service charges = trip kms x.52 $

for rd train , service charges =. trip kms x .56 $


Mac mini, macOS 14.4

Posted on Apr 16, 2024 5:25 AM

Reply
1 reply

Pop up menu as text data format problem in multiplication

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.