Thread
:
IF Statement Help
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
IF Statement Help
if you had numbers you could have used 0
< means NOT equal to
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Jcraig713" wrote in message
...
Thanks is works beautifully!
I was using IF(C1"",C1+91,B1+91)
What does the < that the doesn't?
"CLR" wrote:
Maybe this........
=IF(C1<"",C1+91,B1+91)
Vaya con Dios,
Chuck, CABGx3
"Jcraig713" wrote:
I have a maintenance schedule in excel split by quarter (1,2,3,4 etc).
Along
the left-most column is worksite, Each quarter has a column, due on or
before
and date completed column.
A B C D
E
SITE QTR1 QTR2
1 xxxx Due on/Before Completed Due on/Before
Completed
I have a date in Qtr1 "due on/before" column. What I want to do is, I
guess
it needs to be an IF statement for the date that goes in Qtr2 Due date
such
as:
In D1... If the date in Completed Column(C1) blank, then C1 +91,
else B1+91
Any Suggestions?
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett