Thread: using if and or functions in a formular
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jonno Jonno is offline
external usenet poster
  
Posts: 37
Default 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
Reply With QuoteReply With Quote