Hi all,
Happy New Year all,
I am struggling with something that should be really simple but not working.
I want a formula that states simply:-
If A1>0, Then "One", if B1>0 then "Two", If A1 and B1 are both greater than zero, then "One and Two"
I have tried =IF(and(A1>0,B1>0,"One & Two",A1>0,"One",B1>0,"Two",)) which did not work. I have also tried =IF(A1>0,"One",IF(b1>0,"Two",IF(A1<0+B1<0,"One & Two",))). This will just show "one", but not change for either of the other criteria.
Any help appreciated.
Thanks,
Bookmarks