Syntax Question

[DM]

Hello,

The formulas below are all dependant on an entry being in
column (H)...The formulas them selves are in columns B-G I
want to modify each formulas to say if H is blank then
remain blank...can anyone help me?

Thanx

=VLOOKUP(MONTH(A232),LookUp!$A$13:$B$24,2,FALSE)
=VLOOKUP(WEEKDAY(A232),LookUp!$A$3:$B$9,2,FALSE)
=DAY(A232)
=YEAR(A232)
=WEEKNUM(A232)-WEEKNUM(DATEVALUE(MONTH(A232)&"/1/"&YEAR
(A232)))+1
=WEEKNUM(A232)

 

[Frank Kabel]

Hi
you could use a formula such as
=IF(H232="","",your_existing_formula)

 

[DM]

Thanx...worked like a charm...

Thanx again

-----Original Message-----
Hi
you could use a formula such as
=IF(H232="","",your_existing_formula)

--
Regards
Frank Kabel
Frankfurt, Germany


.