| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
nested function help, please!
I'm trying to write a formula with the following data using Excel '03:
If a student is tardy once, then it costs him $100. Twice, then it costs him $200 and the previous $100 and $200 need to be added to show that it cost him $300 total. If a student is tardy three times, then it costs him $300, plus the previous $100 and $200, for a grand total of $600. I would like this formula to go up to ten tardies and not use Visual Basic. or tables. Thank you! Steve |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested function help, please!
Homework we don't do
-- Don Guillett Microsoft MVP Excel SalesAid Software "Teacher Steve" <Teacher wrote in message ... I'm trying to write a formula with the following data using Excel '03: If a student is tardy once, then it costs him $100. Twice, then it costs him $200 and the previous $100 and $200 need to be added to show that it cost him $300 total. If a student is tardy three times, then it costs him $300, plus the previous $100 and $200, for a grand total of $600. I would like this formula to go up to ten tardies and not use Visual Basic. or tables. Thank you! Steve |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested function help, please!
I'm the teacher, not the student!! I have an Excel SS that I use to
calculate student grades and such. This formula would help me because tardies are a part of student grades. Please help. "Don Guillett" wrote: Homework we don't do -- Don Guillett Microsoft MVP Excel SalesAid Software "Teacher Steve" <Teacher wrote in message ... I'm trying to write a formula with the following data using Excel '03: If a student is tardy once, then it costs him $100. Twice, then it costs him $200 and the previous $100 and $200 need to be added to show that it cost him $300 total. If a student is tardy three times, then it costs him $300, plus the previous $100 and $200, for a grand total of $600. I would like this formula to go up to ten tardies and not use Visual Basic. or tables. Thank you! Steve |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested function help, please!
If you put the number of tardies in A1, you can use this formula to get your
total money! =(A1*(A1+1)/2)*100 If you can't go over 5500, you can use this variation: =MIN(5500,(A1*(A1+1)/2)*100) (10 tardies results in $5500) Teacher Steve wrote: I'm trying to write a formula with the following data using Excel '03: If a student is tardy once, then it costs him $100. Twice, then it costs him $200 and the previous $100 and $200 need to be added to show that it cost him $300 total. If a student is tardy three times, then it costs him $300, plus the previous $100 and $200, for a grand total of $600. I would like this formula to go up to ten tardies and not use Visual Basic. or tables. Thank you! Steve -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested function help, please!
Thanks so much, Dave, that was so simple!!
"Dave Peterson" wrote: If you put the number of tardies in A1, you can use this formula to get your total money! =(A1*(A1+1)/2)*100 If you can't go over 5500, you can use this variation: =MIN(5500,(A1*(A1+1)/2)*100) (10 tardies results in $5500) Teacher Steve wrote: I'm trying to write a formula with the following data using Excel '03: If a student is tardy once, then it costs him $100. Twice, then it costs him $200 and the previous $100 and $200 need to be added to show that it cost him $300 total. If a student is tardy three times, then it costs him $300, plus the previous $100 and $200, for a grand total of $600. I would like this formula to go up to ten tardies and not use Visual Basic. or tables. Thank you! Steve -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
nested function help, please!
It's expensive being a late student these days !! <bg
Pete On Aug 26, 5:13*pm, Teacher Steve wrote: Thanks so much, Dave, that was so simple!! "Dave Peterson" wrote: If you put the number of tardies in A1, you can use this formula to get your total money! =(A1*(A1+1)/2)*100 If you can't go over 5500, you can use this variation: =MIN(5500,(A1*(A1+1)/2)*100) (10 tardies results in $5500) Teacher Steve wrote: I'm trying to write a formula with the following data using Excel '03: If a student is tardy once, then it costs him $100. *Twice, then it costs him $200 and the previous $100 and $200 need to be added to show that it cost him $300 total. *If a student is tardy three times, then it costs him $300, plus the previous $100 and $200, for a grand total of $600. *I would like this formula to go up to ten tardies and not use Visual Basic. or tables. Thank you! Steve -- Dave Peterson- Hide quoted text - - Show quoted text - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested If Function | Excel Worksheet Functions | |||
| nested if function | Excel Worksheet Functions | |||
| can you nested sum and round function within if function? | Excel Worksheet Functions | |||
| Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
| Nested IF Function, Date Comparing, and NetworkDays Function | Excel Worksheet Functions | |||
Linear Mode
