How can I get a discount on Starry Night Backyard software for the classroom?

Posted October 16th, 2008

daphnerst asked: I’m a math teacher and I want to do a unit on astronomy with my students. I have used and love using the program Starry Night Backyard. I’m wondering if anyone knows of a way I can get a discount price for it. My school district won’t purchase it for [...]

How do you calculate the appropiate discount using the IF function on Excel?

Posted April 14th, 2008

m s asked: I am suppose to use the IF function with an absolute reference to the discount value listed (20%). The discount only applies to orders with a quantity of two or more; otherwise the discount is zero. How am I suppose to enter this formula in Excel?
Logical_Test ?
Value_if_true ?
Value_if_false ?DORIS