Custom Formula Functions

[jboschee]

Hi all,

I'm trying to create a formula that will pull numbers from certain fields and multiply them.   Something like this:

If X = Y then (Price*Pack*Units in Pack)

If X = Z then (Price*Pack)

Any help would be appreciated.

Thanks!

[gnans19]

@jboschee

Should be straight formula using If

If X=Y THEN [Price]*[Units in Pack] ELSE [Price]*[Pack] ENDIF

[jboschee]

That's what I originally went with, but I'm getting an error for unknown variable for Y

[gnans19 · Accepted solution]

May be you have space in column name. Try to use square bracket [Y]

[jboschee]

I think I need it to say if column X contains Y then