Hello
I am struggling to write a nested IF statement
I have a column of % weight losses and need to report:
>5% weight loss, (weight loss >5%)
weight loss but <5% (weight loss >0 and <5)
weight stayed the same (weight loss =0)
weight gained (weight loss<0)
I am struggling writing the between weight range and to write a statement that incorporates all the options.
If anyone can help I would appreciate it
Bookmarks