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?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"MAX" wrote in message
...
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

As stated the answer is

=IF(C4<28701,(O73*0.25-3905)/26-PR.1!O75,IF(C428700,(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)
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"MAX" wrote:

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