how to use multiple column condition in App Formula?

AppSheet AppSheet Q&A
1

Hi all id like ask if anyone has idea on how to write the formula in app formula using to column like this:
AND(
([Regular]5)
,
([Special] 5)
)

what i want to achieve is if Regular is selected it will multply by 5 let say input value 3 in Fare column the result is 15 same goes to special.

Regular is a colum same with special.
App Formula for column Fare (Number)

im sorry for my bad english

2

Hi
Try the expression =[_THISROW].[Regular]*5.
The [_THISROW] operator allows you to retrieve a value that is entered in a form field.
#############################################################
Привет!
Попробуйте выражение =[_THISROW].[Regular]*5 .
Оператор [_THISROW] позволяет получить значение, введенное в поле формы.

3

IF() - AppSheet Help