Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Greater than, less than, AS WELL AS value=0
19 views
Skip to first unread message
Stephen Patrick Bass
May 31, 2013, 5:32:25 PM5/31/13
to
Long story short, I'm trying to format something a specific way and excel refuses to validate my formula...so I'm outsourcing to the Google world.
Here's my situation:
I need values greater than 5 in column C to be represented in column D as "Y".
I need values less than or equal to 5 in column C to be shown in column D as "L".
...and here's the kicker...I also need values equal to zero in column C to show up as "N" in column D.
This is the last major bug in a long process of getting a spreadsheet ready for an important consultation with my boss.
Any ideas?
Here's my situation:
I need values greater than 5 in column C to be represented in column D as "Y".
I need values less than or equal to 5 in column C to be shown in column D as "L".
...and here's the kicker...I also need values equal to zero in column C to show up as "N" in column D.
This is the last major bug in a long process of getting a spreadsheet ready for an important consultation with my boss.
Any ideas?
rexcr...@gmail.com
May 31, 2013, 6:49:46 PM5/31/13
to
=IF(C2>5,"Y",IF(C2<=5,"L",IF(C2=5,"N")))
I just assumed that you had your headings/titles in row 1; therefore, I began the sequence with C2. This will get you where you want to be :) Good luck with your boss!
Stephen Patrick Bass
May 31, 2013, 6:53:16 PM5/31/13
to
On Friday, May 31, 2013 3:49:46 PM UTC-7, rexcr...@gmail.com wrote:
> On Friday, May 31, 2013 2:32:25 PM UTC-7, Stephen Patrick Bass wrote:
>
> > Long story short, I'm trying to format something a specific way and excel refuses to validate my formula...so I'm outsourcing to the Google world.
>
> > I tried this formula, and there were no value errors. Unfortunately, all of the values in Column C that were zero did not change into "N" for column D. It's like it ignores that part of your formula. I'm not saying you're wrong, but this isn't quite what I need.
> On Friday, May 31, 2013 2:32:25 PM UTC-7, Stephen Patrick Bass wrote:
>
> > Long story short, I'm trying to format something a specific way and excel refuses to validate my formula...so I'm outsourcing to the Google world.
>
Thanks for the help though. Any other ideas?
Zaidy036
May 31, 2013, 7:07:40 PM5/31/13
to
h2so4
May 31, 2013, 7:19:08 PM5/31/13
to
Zaidy036 presented the following explanation :
> On 5/31/2013 6:53 PM, Stephen Patrick Bass wrote:
>> On Friday, May 31, 2013 3:49:46 PM UTC-7, rexcr...@gmail.com wrote:
>>> On Friday, May 31, 2013 2:32:25 PM UTC-7, Stephen Patrick Bass wrote:
>>>
>>>> Long story short, I'm trying to format something a specific way and excel
>>>> refuses to validate my formula...so I'm outsourcing to the Google world.
>>>
>>>> I tried this formula, and there were no value errors. Unfortunately, all
>>>> of the values in Column C that were zero did not change into "N" for
>>>> column D. It's like it ignores that part of your formula. I'm not
>>>> saying you're wrong, but this isn't quite what I need.
>>
>> Thanks for the help though. Any other ideas?
=IF(C2>5,"Y",IF(C2=0,"N","L"))
>> On Friday, May 31, 2013 3:49:46 PM UTC-7, rexcr...@gmail.com wrote:
>>> On Friday, May 31, 2013 2:32:25 PM UTC-7, Stephen Patrick Bass wrote:
>>>
>>>> Long story short, I'm trying to format something a specific way and excel
>>>> refuses to validate my formula...so I'm outsourcing to the Google world.
>>>
>>>> I tried this formula, and there were no value errors. Unfortunately, all
>>>> of the values in Column C that were zero did not change into "N" for
>>>> column D. It's like it ignores that part of your formula. I'm not
>>>> saying you're wrong, but this isn't quite what I need.
>>
>> Thanks for the help though. Any other ideas?
Stephen Patrick Bass
Jun 3, 2013, 12:33:38 PM6/3/13
to
0 new messages