paularthur
New Member
- Joined
- Mar 12, 2015
- Messages
- 12
Hello,
I'm having trouble trying to get my head around an Excel function. I have an example below to give you an idea of what I want to achieve.
So if A1 was 50 all of the conditions are met so I want the output to be all the outcomes for example
Is equal to 50, its less than 100, Greater than 49.
If A1 was 60 it would give;
its less than 100, Greater than 49.
Would I need to do this in VBA or is there any other feature of Excel that would make this easier?
Thank you in advance for any help.
Paul
I'm having trouble trying to get my head around an Excel function. I have an example below to give you an idea of what I want to achieve.
Excel Formula:
=IF(A1=50,"Is equal to 50",IF(A1<100,"its less than 100",IF(A1>49,"Greater than 49","blah")))
So if A1 was 50 all of the conditions are met so I want the output to be all the outcomes for example
Is equal to 50, its less than 100, Greater than 49.
If A1 was 60 it would give;
its less than 100, Greater than 49.
Would I need to do this in VBA or is there any other feature of Excel that would make this easier?
Thank you in advance for any help.
Paul