Skip to main content
Question

Formula help

Forum|alt.badge.img+8

I currently have this 

If([Tour - Salesroom]= " Solmar-New", [Sales Manager]= "Mark Torontow",[Sale - Purchase Price]*ToNumber([Sales Manager Point])/100 

first I am getting a yellow notice at end of 100 thought I needed ) but still yellow but I want to add more to this statement.

 basically need to say

If (Tour-Salesroom]= "Solmar-New" then pick Mark jones name in Sales Manger field (frop down list)  and pick 4% in sale point field (drop down list or if salesroom is VIP then pick James Dean in sales manager and pick 1.8% ins salepoint field. 

I donn't know what all the "fuctions do in writing a formula.

thanks inadvance 

 

 

This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

A text or numeric formula in QuickBase is similar to Excel, in that it performs a calculation.  It does not set the value in fields.

 

i suggest that you explore using Form Rules to populate certain fields based on the Tour Type And the sales points rate.

Mark Shnier. Your Quickbase Coach
Terms & ConditionsAccessibility statement