charlie haffey norwood public schools for situations that have: yes or no true of not true one or...
TRANSCRIPT
![Page 1: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/1.jpg)
Charlie Haffey
Norwood Public Schools
IF Functions
![Page 2: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/2.jpg)
For situations that have:
Yes or No
True of Not True
One or the other
IF Functions
![Page 3: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/3.jpg)
The argument or condition
Value if condition is true/met
Value for otherwise
IF Functions- 3 parts
![Page 4: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/4.jpg)
If the score is below xxxx
If the date is between xx and xx
If the value = a benchmark
Arguments
![Page 5: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/5.jpg)
Is the date rcvd on or before 9/15
If true,
Valid
If false,
You’re screwed
AAPS forms
![Page 6: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/6.jpg)
IF Function Dialog Box
![Page 7: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/7.jpg)
Notice reference to cell,
not the date itself
![Page 8: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/8.jpg)
![Page 9: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/9.jpg)
Copy Function thru Range
![Page 10: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/10.jpg)
Holy Crap!
![Page 11: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/11.jpg)
We used aRelative Reference
For The Date In The Argument!
![Page 12: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/12.jpg)
Highlight reference in initial cell
Easily Solved
Fourth Function Key- F4
This now an Absolute Reference
![Page 13: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/13.jpg)
Redo Fill
![Page 14: Charlie Haffey Norwood Public Schools For situations that have: Yes or No True of Not True One or the other](https://reader035.vdocuments.us/reader035/viewer/2022070308/551c0b065503469e4f8b5105/html5/thumbnails/14.jpg)
Charlie Haffey
Norwood Public Schools
IF Functions