View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Niek Otten Niek Otten is offline
external usenet poster
 
Posts: 3,440
Default 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