Excel - IF Functions

Closed

Cde - Aug 13, 2010 at 05:41 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 17, 2010 at 11:24 PM

Hi ,

I made a forumlua that finds the difference between the date of one cell against todays date to get the total number of days that have gone past since they started. I need help making a if function that will flag YES if the total of days in the cell = either 1 or mutipules of three thereafter ie 1,4 ,7 ,10 ,13

Any help would be appericated

Thanks

Excel - IF Functions
Excel date format dd.mm.yyyy - Guide
Functions of spreadsheet - Guide
Transfer data from one excel worksheet to another automatically - Guide
Excel functions in french - Guide
Number to words in excel - Guide

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Aug 17, 2010 at 11:24 PM

You can use

=IF(OR(A2="", A2<=0), "", IF(AND(A2>0, MOD(A2-1,3)=0), "YES", "No"))

Similar discussions

How to use conditional format based on text?

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

Excel multiple functions in one cell

Similar discussions

Subscribe To Our Newsletter!