| 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 | |||
Hybrid Mode
