What is the best way to create a formula that will give me the equivalent of the Excel if function. The specific example I have is if a control valve is closed (.OP <= 0) then I want the formula to give me zero flow, other wise I want it to just give me the flow reading. So something like this in Excel
EXCEL IF(x,y1,y2)
in General Seeq Discussions
Posted
What is the best way to create a formula that will give me the equivalent of the Excel if function. The specific example I have is if a control valve is closed (.OP <= 0) then I want the formula to give me zero flow, other wise I want it to just give me the flow reading. So something like this in Excel
IF(OP<=0,0,FLOW)
Thanks for your help.