I can’t seem to get this to work right. I have 3 columns involved: a text column for a sales rep’s name, a ‘billed amount’ and a commission column (column with formula). I want to be able to calculate the commission column by multiplying the billed amount by 2.5% only if the sales rep column has a v…

@bartleby Try this: IF({Sales Rep}<>"",TEXT(MULTIPLY({Billed Amount},2.5%),"$#.##.00"),0) Actually, after a second look, I think the only issue was that you want to check {Sales Rep} <> “” instead of <> “0”.

Calculate only if column has value formula help

Platform discussions Special workflows & use cases

system (system) Closed May 19, 2021, 2:20pm 4

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.

Topic		Replies	Views
Calculate value based on statuses in formula column Special workflows & use cases formula	3	28	October 22, 2024
Need to display a blank field instead of $0 Special workflows & use cases formula , numbers , question	7	1338	August 14, 2023
Column formula, using IF, IF AND or SWITCH Platform discussions columns , formula	15	7950	June 21, 2021
Formular that can handle null values in multiple cell Platform discussions columns , formula	4	647	October 20, 2023
Additional query to current IF statement Platform discussions formula	5	160	June 12, 2024

Calculate only if column has value formula help

Become part of our community groups

Can't find what you're looking for?

Can't find
what you need?

Calculate only if column has value formula help

Related topics

Become part of our community groups

Can't find what you're looking for?

Can't findwhat you need?

Can't find
what you need?