Previous Topic Next Topic

IF Formula Query

Closed
eterry Posts 1 Registration date Monday January 4, 2016 Status Member Last seen January 4, 2016 - Jan 4, 2016 at 11:48 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 5, 2016 at 11:38 AM
Hi there,

I have a spreadsheet which using the IF formula should be bringing back either "update Required" or "N/A" depending on if the date in the cell is +21days and greater than today's date. However it is not bringing back the "N/A" false response? $M$1 is ref for TODAY() date. The J column contains either dates, blank cells, or 'TO BE SENT' text.
I hope this makes sense. any help is much appreciated.

The formula is:

=IF($M$1>=(J35+21),"Update Required","N/A")

Cheers in advance :)

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jan 5, 2016 at 11:38 AM
Try this
=IF(AND(ISNUMBER(J35), $M$1>=(J35+21)),"Update Required","N/A")
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response