How do i enter this as a formula into excel IF function?
1 answer:
You might be interested in
Answer:
(Answers may vary.)
My Considerations
The Go Green Club has a total of 100 members. I plan to photograph each of them in front of our club's "Go Green" sign. I have a deadline of 30 days to deliver the ID cards. Therefore, I have to ensure that all the cards are printed and ready for delivery in 20 days, with 10 days of buffer time (in case the cards require any edits or changes). Additionally, after I have submitted the draft for review, I will need the coordinator's final approval on the design and layout of the ID card.
Hardware Requirements
- a desktop computer or laptop with adequate memory to run the software to create the ID cards
- some external storage devices, such as pen drives and DVD disks, to share the design and layout for the coordinator to review; I will also need these devices to store the final digital file for print
- a color scanner to scan hand-drawn artwork and signatures, which I will place on the ID card
- a digital camera to capture photos of members, and to transfer them to the computer/laptop
- a printer to make hard copies of the cards.
- Software Requirements
I intend to use Scribus to create the ID cards because it is a free DTP application, and has most of the common features I'd need to create an ID card.
Formatting Techniques
- I plan to use the following techniques to design the club ID cards.
- I'll use the landscape or horizontal orientation. This will enable proper spacing for the ID card elements.
- I'm planning to use a card measuring 3.370 inches × 2.125 inches. A card this size will ensure that all the elements of the card are visible.
- I am planning to place the club logo on the top left corner, because the eye normally follows the path of the letter Z. This'll help the viewer to see the logo and identify/recognize the club.
- Next I'll place the club name; I'll use the top-center alignment and also vertically align it to the logo. I'll use the sans serif font for the club name.
- Following the Z-path rule, I'll place the member's photo to the right and the member's name under the photo. In this position, the photo and the name will be visible, and will not get mixed up with other elements. I'll print the member name with a serif font.
- Finally, again in line with the Z-path rule, I'll position the club seal and the club director's signature at the right lower bottom. Although these elements are essential on an ID card, they do not require as much viewer attention as the club logo, name, and member photo.
Explanation:
I used Canva for this card.
