Two formulas in one cell

  • Thread starter Thread starter MAX
  • Start date Start date
M

MAX

I want these two formulas in cell B2.
1. When cell C4 < 28701 I want to use this -> (O73*(0.25)-3905)/13*2-PR.1!O75.
2. When cell C4 > 28700 I want to use use -> (O73*(0.35)-6775)/13*2-PR.1!O75
 
So, what id C4 is 28700.5? Then both conditions are met. And what if C4
=28702? Or 28699?
Are you sure you don't mean something else?
 
As stated the answer is

=IF(C4<28701,(O73*0.25-3905)/26-PR.1!O75,IF(C4>28700,(O73*0.35-6775)/26-PR.1!O75,""))

However, I suggest you hand calculate the result and verify that the logic
of the Excel formula matches the desired result, because there are a number
of issues here. First something can be less than 28701 AND greater than
28700 are the same time - 28700.5. Second, the operation -PR.1!O75 occurs
after the division, so if you want it in the numerator this formula won't do
it.

I removed a couple of unnecessary parenthesis.

If the numbers are integers then the above can be written
=IF(C4<28701,(O73*0.25-3905)/26-PR.1!O75,(O73*0.35-6775)/26-PR.1!O75)
 
Back
Top