I am trying to create a formulae where the following table is true and the output as provided. Tried usin the nested if function but can not seem to make sense. Table will probably be 100 rows long and could have any combinations of numbers in them. Basically though if there is a recorded Critical regardless of other values it must always be sad, if there are and major or minor but no critical it must be neutral and if there are any minor but no major or critical it must be happy.
Thanks in advance
Thanks in advance
Critical | Major | minor | output |
Any value >=1 | Any value >=0 | Any value >=0 | sad |
value =0 | Any value >=1 | Any value >=0 | neutral |
value =0 | Any value >=0 | Any value >=1 | happy |