Question about =If Formula??? 3 Values

[yeaboii]

Hi all,
Is it possible to have an = if formula to have 3 values for instance my current one has 2 (see below) however i was hoping that i could add another value for an item coming up to date for instance 1= in date 0.5 = comming up and 0 = Out of date currently i have 1 and 0 but i would like to have those 3?

=IF("Training - Roster-Training'!AB54>=TODAY()-730,1,"0") = this creates a 1 if within the 730 days and 0 if after.

 

[NARAYANK991]

Hi ,

One IF statement can test for one condition , and depending on the two values of that condition , which are TRUE or FALSE , there can be two outputs.

We can always nest one IF statement within another , so that we can test for two conditions , each with its own values of TRUE or FALSE , so that we can 3 outputs.

This kind of nesting can go quite deep , enough for most requirements.

If you can upload your workbook and specify your conditions , the Excel formula can be written.

Narayan

 

[Peter Bartholomew]

Step changes do not always require IFs. Here I have used
= SUM( ([@date] >= (TODAY()-interval) ) / COUNT(interval) )
where interval refers to a sequence of 4 steps
={0,182,365,730}

 

[p45cal]

alternatively, if cell C4 contains your date:
=CHOOSE(MATCH(C4-TODAY(),{-9000000,0,10}),0,0.5,1)
where coming-up date is 10 days hence.