Comments on: How to Create an Excel Formula

on 7/14/2008 Can someone to is more knowledgeable than me help me with the following question:
An incoice dated March 12 is paid on March 25. The amount on the bill is $1,600 and the credit are 2/10, n/30 What amount should be paid? I know that is 1,600 but i need to show the formula....please help . miss_catrachita@yahoo.com

on 2/19/2008 Does anyone know how to create a formula in excel to answer this type of question. Classroom A has 5 students going to Yale, Classroom B has 2, Classroom C has 14. If I have "Yale" next to their name, how can I get a running count on the total number of students that will attend Yale?

on 9/12/2007 I'm wondering, is there a way to put a generic formula in a row in a given row.

For example, I am trying to put the same formula in each cell in the entire column which calculates a number from another cell in that particular row. Say the formula is in B2. B2 knows to get its number from A2, not A1. And this same formula will be placed in all of the cells in the B column.

How do I do this?

Send the reply to sbhawk@gmail.com if you can please

on 7/1/2007 Some one asked me what formula could be use in Excell for calculation. I have no idea I usually works in the excel but never knew what are there formulas can be use in calculation. Could you help me no this?

ppostman@hotmail.com

on 1/22/2007 Need Help,
Trying to do a school lunch menu in excel. Want to enter codes such as f=fruit s=salades H= hotdogs etc. Next to each student name on a daily bases I want to be able to put in code etc f,s where f=$.50 and s=$3.00 and have it totaled in weekly bill. this way I can show the parents what the student ordered and the cost Is there a way to enter a letter or group os letter in a cell and have it total in this way ? ? ?
James Howell
jhowll.jr@gmail.com

on 1/22/2007 IF((C4:C11="midia"),SUMPRODUCT((D4:D11)*(E4:E11)))
in c cell firstly find "midia" from C4 to C11 then sumproduct of the multiple of D4 * e4