CONNETING TWO FORMULAS THAT WORK INDEPENDTLY BUT NOT TOGETHER

(0) Share

Report

Posted on by CU11072121-0

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)

All responses (1)

Answers (0)

Jonas "Jones" Melgaard 4,770 Super User 2025 Season 2 on at

Like (0)

Report

CONNETING TWO FORMULAS THAT WORK INDEPENDTLY BUT NOT TOGETHER

Hi @CU11072121-0,

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 (-:

Was this reply helpful? Yes No