I'm cleary missing something, because none of the above appear to answer my problem. Perhaps my explanation was somewhat vague? Simply what syntax, if that's the correct expression, should be substituted for the words 'Negative'and or 'Positive'in the following formula: @IF(R29=NEGATIVE,?,@IF(R29=POSITIVE,?,0))
The simple lotus function is @IF(condition,true value,false value)
You seem to need to start with @IF(R29<0, what you enter after that depends on what you want to do with the information. The formula I gave in my earlier post will put in the cell either x or y, since the " " marks indicate insert a string. Some instruction is needed if you wanted to carry out a calculation based on the result or go to another part of your spreadsheet.