| Assalamoalaikum, We hope you will enjoy your visit here. Join our community! If you're already a member please log in to your account to access all of our features: |
| Indicators for the maximal and minimal values | |
|---|---|
| Tweet Topic Started: Apr 26 2007, 06:57 PM (123 Views) | |
| Ahmaq | Apr 26 2007, 06:57 PM Post #1 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
Problem: Creating a formula that will indicate the maximum and minimum values in List1 by returning ""Max Value"" or ""Min Value"" in the cell next to them. Solution: Enter the following IF statement, using the MAX and MIN functions, in column B: =IF(A2=MAX($A$2:$A$8),""Max Value"",IF(A2=MIN($A$2:$A$8),""Min Value"","""")) |
![]() |
|
| Ahmaq | Apr 26 2007, 06:58 PM Post #2 |
![]()
Hum sa ho to saamnay a'ay
![]()
|
Posted Image |
![]() |
|
| 1 user reading this topic (1 Guest and 0 Anonymous) | |
| « Previous Topic · Roshnee · Next Topic » |








5:32 AM Jul 11