Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formular | New Users to Excel | |||
I still need help with formular? | Excel Worksheet Functions | |||
formular | Setting up and Configuration of Excel | |||
If formular | Excel Discussion (Misc queries) | |||
Need Help With A Formular | New Users to Excel |