Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formula
I am having trouble coming up with a formula and hope someone here can help
me. I am trying to have a single cell be able to provide one of three results for a calculation. Example : If the average of cells A1:D1 are less than 90 then I want a certain number to display in cell F1. If that same average is between 90.1 and 97 I want it to display a different result in F1. And if that same average is 95.1 or higher I want the display to be yet another, different result in F1. I am pulling my hair out trying to figure how to get 3 different results to display. I can get two, but not the third. HELP!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
Formula, Conditional Formula Needed | Excel Discussion (Misc queries) | |||
Conditional Formula | Excel Worksheet Functions | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
Help with a conditional formula | Excel Worksheet Functions |