| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change result #VALUE! to "message"
My formula returns last value in column of numbers. If all cells in range are blank, the formula returns #VALUE!. I would like formula to return message "No Scores". I have tried IF formula but keep getting message re circular reference
Can following formula be modified? =INDEX(B35:B49,COUNTA(B35:B49),1 Thank Bob Leonar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change result #VALUE! to "message"
=IF(COUNTA(B35:B49)=0,"No Scores",INDEX(B35:B49,COUNTA(B35:B49),1))
rleonard wrote: My formula returns last value in column of numbers. If all cells in range are blank, the formula returns #VALUE!. I would like formula to return message "No Scores". I have tried IF formula but keep getting message re circular reference. Can following formula be modified?? =INDEX(B35:B49,COUNTA(B35:B49),1) Thanks Bob Leonard |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change result #VALUE! to "message"
One way:
=IF(COUNTA(B35:B49),INDEX(B35:B49, COUNTA(B35:B49),1),"") In article , "rleonard" wrote: My formula returns last value in column of numbers. If all cells in range are blank, the formula returns #VALUE!. I would like formula to return message "No Scores". I have tried IF formula but keep getting message re circular reference. Can following formula be modified?? =INDEX(B35:B49,COUNTA(B35:B49),1) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change cell value result from "FALSE" to blank or zero | Excel Discussion (Misc queries) | |||
| Formula Result is "V6", need Excel to use cell "V6", not the resul | Excel Worksheet Functions | |||
| How do I change the column heading in Excel to display "A" "B" "C | New Users to Excel | |||
| change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
| =IF(D13="PAID","YES","NO") Can I change fonts colour | Excel Discussion (Misc queries) | |||
Linear Mode
