help with macro
Thank you!!
"Joel" wrote:
This function gave me the same answerr as the worksheett function
Function GetGest(cell As Range)
If IsEmpty(cell) Then
GetGest = ""
Else
GetGest = 40 - ((cell - Date) / 7)
End If
End Function
"hannatrip" wrote:
it works that way, but i cant get it to lock and im afraid when one of the
unit clerks makes a mistake and deletes it it will lose it all. orr what am I
doing wrong in locking the cell with the formula in it??
"Joel" wrote:
I got it to work with no changes. Before putting the formula into worksheet
make sure C3 is empty. Highlight the cell where you want the formula and
then paste the forula at the top of the worksheet in the fx box (formmula
box). It shuold work.
"hannatrip" wrote:
I would like to make a macro with the following formula
=IF(C3="","",((40-((C3-(TODAY())))/7)))
it needs to calculate a gestational age when the due date is put in from L5
to L169..
I cant seem to get it to lock so the formula doesnt get deleted so I thought
a macro would work??
|