| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need a Formula
I need a formaula to do the following. If the total in cell A1 is between
0-60 I want it to display the word Pass in cell B1. If the If the total in cell A1 is between 61-80 I want it to display the word Credit in B1. If the If the total in cell A1 is between 81-100 I want it to display the word Distinction in B1. I am sure someone would know how to do this!!! Please help. You will make my life so much easier!!! Cheers -- Karen |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a Formula
=IF(A1<61,"Pass",IF(A1<81,"Credit","Distinction"))
-- Gary's Student "Karen" wrote: I need a formaula to do the following. If the total in cell A1 is between 0-60 I want it to display the word Pass in cell B1. If the If the total in cell A1 is between 61-80 I want it to display the word Credit in B1. If the If the total in cell A1 is between 81-100 I want it to display the word Distinction in B1. I am sure someone would know how to do this!!! Please help. You will make my life so much easier!!! Cheers -- Karen |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a Formula
Thank you, thank you, thank you !! Just one more question. Is there two
brackets at the end because one is for the total formula and the other is for the formula within? So if I was to add a fail would it be =IF(A1<50,"Fail",IF(A1<61,"Pass",IF(A1<81,"Credit" ,"Distinction"))) If this is right, you are a really good teacher!!!! Thanks again -- Karen "Gary''s Student" wrote: =IF(A1<61,"Pass",IF(A1<81,"Credit","Distinction")) -- Gary's Student "Karen" wrote: I need a formaula to do the following. If the total in cell A1 is between 0-60 I want it to display the word Pass in cell B1. If the If the total in cell A1 is between 61-80 I want it to display the word Credit in B1. If the If the total in cell A1 is between 81-100 I want it to display the word Distinction in B1. I am sure someone would know how to do this!!! Please help. You will make my life so much easier!!! Cheers -- Karen |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
I need a Formula
Your formula is correct if you want "Fail" to be between 0 and 49.
If you want "Fail" to be between 0 and 50 then change your formula to: =IF(A1<51,"Fail",IF(A1<61,"Pass",IF(A1<81,"Credit" ,"Distinction"))) Have a pleasant day ! -- Gary's Student "Karen" wrote: Thank you, thank you, thank you !! Just one more question. Is there two brackets at the end because one is for the total formula and the other is for the formula within? So if I was to add a fail would it be =IF(A1<50,"Fail",IF(A1<61,"Pass",IF(A1<81,"Credit" ,"Distinction"))) If this is right, you are a really good teacher!!!! Thanks again -- Karen "Gary''s Student" wrote: =IF(A1<61,"Pass",IF(A1<81,"Credit","Distinction")) -- Gary's Student "Karen" wrote: I need a formaula to do the following. If the total in cell A1 is between 0-60 I want it to display the word Pass in cell B1. If the If the total in cell A1 is between 61-80 I want it to display the word Credit in B1. If the If the total in cell A1 is between 81-100 I want it to display the word Distinction in B1. I am sure someone would know how to do this!!! Please help. You will make my life so much easier!!! Cheers -- Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
Hybrid Mode
