You just need to utilise one nested IF function if you have to write an IF statement with three outcomes. The first IF statement will handle the first possible outcome, while the second and third will be returned by the second and third IF statements, respectively. Note that if you have Office 365 installed, you can use the new IFS feature as well.
The Excel OR function returns TRUE if any of the supplied arguments is TRUE, and FALSE if all of the supplied arguments are FALSE. To test A1 for "x" or "y," for example, use =OR(A1="x",A1="y").
Learner's Ratings
3.7
Overall Rating
50%
20%
5%
7%
18%
Reviews
H
Harshada Munfan
5
Nice course
P
Pratik Meshram
5
where is assignment PDF
Gourav Parmar
5
Hey Provide me the Practice File
G
Gitesh Saini
5
This aap very helpful for human
R
Rishu Baghel
4
sir, can you provide us some table for practice?
S
shams faishal
4
please provide your excel file so it will be easy to learn fast
P
Pintu Kumar
5
improve video quality, because its excel file and the pixel is not good.
Share a personalized message with your friends.