If statement formula

[lintan]

Column A contains the date and Column B contains the data. I would like to
create an IF statement showing the date of any data in Column B that exceeds
100.

 

[Frank Kabel]

Hi
use 'Data - Filter - autofilter' for this

 

[Dave R.]

If A does actually contain a date and you simply want to make it visible/not
based on B, you can use conditional formatting.

Choose the A cell like A1

format>conditional formatting>formula is =B1<=100
and set the format the same color as the background (making them
indistinguishable).

You can then copy this A1 formula down through A2:A2000 or whatever using
copy/paste special>formats.

 

[lintan]

Thank for your help. What I actually want to do is if any data in Column B
exceeds 100, a statement such as "Usage exceeded limit on (the date of
exceedance)" will show up. Below is part of my spreadsheet:

Column A Column B
1/1/04 90
1/2/04 103
1/3/04 110
1/4/04 85

I want to show a statement saying "Usage exceeded limit on 1/2/04, 1/3/04".

 

[Dave R.]

In C1
=IF(B1>100,TEXT(A1,"m/d/yy")&" ","")
then paste through C5 then use

="Usage exceeded: "&C1&C2&C3&C4&C5

 

[BenjieLop]

Column A contains the date and Column B contains the data. I would lik
to
create an IF statement showing the date of any data in Column B tha
exceeds
100.

Assume that the date is in Column A and the data in Column B, ente
this formula in Cell C1 and copy down as required:

=if(B1>100,A1,""

 

[lintan]

This works but how do I separate the dates in the "Usage exceeded:
"&C1&C2&C3&C4&C5"