web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Engage with the Community / CONNECTING TWO FORMULA...
Engage with the Community
Unanswered

CONNECTING TWO FORMULAS THAT WORK INDEPENDTLY BUT NOT TOGETHER

(1) ShareShare
ReportReport
Posted on by CU11072121-0 2
i HAVE TWO FORMULAS, FIRST IS TO CALC IF CELL >100 THEN PUT,100+20 :SECOND IS TO CALC IF SAME CELL <100,CELL*.29-CELL
THIS  IS A LITTLE RUFF BUT THEY work INDIVIDUALY,  SO I need to glue them together. basically  if first is met, gives the correct answer if not go to formula 2 for correct answer. ALL In one formula. hope i did not make a fool of myself, x cfo but now 77, and i lost ability. Thanks ps if someone answers how do i find it.
I have the same question (0)
  • Jonas "Jones" Melgaard Profile Picture
    Jonas "Jones" Melgaard 4,988 Most Valuable Professional on at
     
    I'm not entirely sure what you want, but I assume it's Excel.
    I'd use the IF function, so something like =IF(Cell > 1, First Formula, Second Formula), or =IF(A1>100,A1+20,A1*0.29-A1). PowerFx should works about the same. 
     
    Otherwise Copilot is really good at helping with formulas (-:
  • Martin Dráb Profile Picture
    Martin Dráb 238,127 Most Valuable Professional on at
    @CU11072121-0 Do you still need an answer? If so, please tell us which product you're talking about, so we can move the thread to the right forum and give you information relevant to what you need.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Season of Giving Solutions is Here!

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Engage with the Community

#1
Jonas "Jones" Melgaard Profile Picture

Jonas "Jones" Melgaard 13 Most Valuable Professional

#2
Layan Jwei Profile Picture

Layan Jwei 7 Super User 2025 Season 2

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 6 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Welcome to the Engage with the Community forum

Product updates

Dynamics 365 release plans