using if and or functions in a formular
 

Hi,

I have this formular

=IF(B1290,((B128+B129-B125)*(J130-J131)*0.00000785),(0))

But now i need to add a or function referancing another cell B130 so if B129
or B130 is greater then 0. a bit like this.

=IF(B129orB1300,((B128+B129-B125)*(J130-J131)*0.00000785),(0))

but i carnt get it to work.

Please Help!!!

--
Jonno

using if and or functions in a formular
 

=IF(OR(B1290,B1300),((B128+B129-B125)*(J130-J131)*0.00000785),(0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jonno" wrote in message
...
Hi,

I have this formular

=IF(B1290,((B128+B129-B125)*(J130-J131)*0.00000785),(0))

But now i need to add a or function referancing another cell B130 so if
B129
or B130 is greater then 0. a bit like this.

=IF(B129orB1300,((B128+B129-B125)*(J130-J131)*0.00000785),(0))

but i carnt get it to work.

Please Help!!!

--
Jonno

using if and or functions in a formular
 

Thank you very much this works perfect!!!!!!
--
Jonno


"Niek Otten" wrote:

=IF(OR(B1290,B1300),((B128+B129-B125)*(J130-J131)*0.00000785),(0))

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Jonno" wrote in message
...
Hi,

I have this formular

=IF(B1290,((B128+B129-B125)*(J130-J131)*0.00000785),(0))

But now i need to add a or function referancing another cell B130 so if
B129
or B130 is greater then 0. a bit like this.

=IF(B129orB1300,((B128+B129-B125)*(J130-J131)*0.00000785),(0))

but i carnt get it to work.

Please Help!!!

--
Jonno