• 470K Members
• 6,236 Online
• 568K Conversations

IF Formula trouble

Occasional Visitor

IF Formula trouble

I'm almost embarrassed to ask this, but having a heck of a time finding an answer.

I'm tracking Gross Commissions for salespeople at my company, and when they reach a specific target their commission split changes to a higher split.

This is the formula I'm using:

=IF(\$D\$1<\$F\$3,(E6-F6)*\$B\$3,(E6-F6)*\$D\$3)

\$B\$3 is 80%.

\$D\$3 is 85%

The problem I'm having: Once the commission target is reached and the split goes from \$B\$3 to \$D\$3 all of the previous commissions that were calculated at \$B\$3 are recalculated at \$D\$3.

Is there a way to lock the formula at \$B\$3 once the value has been calculated?

I've been working on this for a week and I can't afford to pull out more hair.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies