burnout421
Technical User
I am using this formula in Excel:
=IF(OR(F5="",H5="",I5=""),"",F5+H5-I5)
This means that unless all of F5, H5 and I5 are occupied, no result will be shown. If I open the file in 123, the formula is converted as follows:
@IF(((F5="")#OR#(H5="")#OR#(I5="")),"",F5+H5-I5
The result is not the same though. I am not experienced and would appreciate help with a formula that will produce the same results as the excel formula.
=IF(OR(F5="",H5="",I5=""),"",F5+H5-I5)
This means that unless all of F5, H5 and I5 are occupied, no result will be shown. If I open the file in 123, the formula is converted as follows:
@IF(((F5="")#OR#(H5="")#OR#(I5="")),"",F5+H5-I5
The result is not the same though. I am not experienced and would appreciate help with a formula that will produce the same results as the excel formula.