IF Statement for On One Cell Comparing to the Other Cell
Thanks, that worked!
"Sheeloo" wrote:
You can not check the value in a cell and then poplulate that cell itself so
you need to enter this in R (or whatever is available)
=IF(M1<"",Q1,"")
This will check for blank cell M1 and populate with value in Q1 only if it
is NOT blank.
"Daren" wrote:
Hello,
I have a column with a text value in it, for example Z01. I need to
determine if that value should be in the cell only if a date appears in
another cell. The Z01 column is Q and the date that is formatted as
m/dd/yyyy is in column M.
Thanks!
|