I am trying to check the value of 2 calculations like total number of staff and the breakdown of that total number of staff by cadre, I want to know which syntax I will use so that when the 2 figures are not equal, it will prompt error message
@aogugua, could you share a dummy question and your condition for this? Maybe the community should be able to help you out looking at the same.
koboform.xlsx (9.8 KB)
the comment is not part of the form, I just inserted it there to explain what I want
As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet. It is possible to nest multiple IF functions within one Excel formula for Excel with 4 outcomes. You can nest up to 7 IF functions to create a complex IF THEN ELSE statement.
