IF function

  • Thread starter Thread starter Jeff Mackeny
  • Start date Start date
J

Jeff Mackeny

Can anyone help me create a IF function

if date is = or > then the current date =sheet!j2

also what do I need to add to a formula to show a blank cell if the results
is 0
 
Hi Jeff

try
=IF(A1>=Now(),sheet1!j2,"")

this will compare the value in A1 (your date) to the current date and if the
date is greater than or equal to the current date it will populate the cell
with the formula with whatever is in sheet1, cell j2 otherwise it will leave
it blank.

Hope this is what you were after.

Cheers
JulieD
 
so I always need to have =now() in A1, if yes can is it possible to check
the pc's data?
 
Hi Jeff

no, the A1 is the cell with the date you want to compare to the current date
.... the =NOW() in the formula gets the current date off your machine

actually now() gets the date & time, you might want to use today() instead.

Let me know how you get on.

Cheers
JulieD
 
Julie,
Sorry im confused, let me give you more details, I have a workbook that
keeps track of peoples payments per month, so I have a Jan sheet Feb sheet
and so on, in addtion I have a master list sheet where i will enter all info
and then point all other sheets to this list, so if the MasterList sheet has
'John Doe' in B3 i would point the B3 cell on all other sheets to
MasterList!B3, ok this is easy, here comes the tricky part, lets say that
the name is B3 changed to 'Jim Smith' in Apr, i would then go to the
Masterlist sheet and change B3 to 'Jim Smith' I dont however want B3 to
change on the Jan, Feb and Mar sheet, the jan sheet should still say 'John
Doe'

I hope I was clear

Thanks for your help Julie
 
Hi Jeff

okay this makes a bit more sense now, please completely disregard my earlier
answers :)

the thing that concerns me first off, is that you need to manually check
that none of the names have changed position on a monthly basis ... is there
any reason why you can't make B3 always be John Doe?

If you can't then i'm not sure of the best solution ... other than a code
one that once a name has been written into a cell on a monthly spreadsheet
it is automatically changed to a value and not a formula any more. Would
this work in your situation?

Cheers
JulieD
 
Julie,

The reason peoples names change is because, this is a tenant list where I
enter all payments, if I have a new tenant moving in on Mar, I still would
still need to keep the old tenant info on file
 
Hi Jeff

as no-one else has joined in this conversation i would suggest re-posting a
new question maybe asking for code that will change the value of a cell
from a formula to a value when a number is placed in an another cell on the
worksheet

ie if Sheet2!B3 contains =Sheet1!B3
but when you enter their rent payment, i.e. in column C3
then you want Sheet2!B3 to contain the result of the formula and not the
formula itself.

i could write it (i think) but its 3am here and i really should be off
getting some sleep!

hope you solve it
Cheers
JulieD
 
Back
Top