Forum Discussion
mbotti215
Oct 18, 2019Copper Contributor
A complex IF, Then statement.
I have an established Repair Order Work Form. I'm hoping to explain this well enough. That someone is able to help me write the formula I need. I have basically 4 columns A is the amount of items sol...
Twifoo
Oct 19, 2019Silver Contributor
The formula in D27 could be:
=IF(A27=1,
D26*0.85,
“”)
=IF(A27=1,
D26*0.85,
“”)