Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function
I was wondering if it is possible to add to this formula, if all cell values
are blank than formula returns, blank. Current Formula in AB2 =IF(W2="Unknown","Unknown",MAX(X2,SUM(Y2:AA2))) W2 - this cell may have a text value of "Unknown", if so cell value in AB2 would return "Unknown", if not than look at X2 (numeric) and determines if that value is greater than the sum of Y2:AA2 (all numeric), and returns which is greater. I need to have it return blank of W2 through AA2 have no values. Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If Function
=IF(COUNTA(W2:AA2),IF(W2="Unknown","Unknown",MAX(X 2,SUM(Y2:AA2))),"")
"Jen_T" wrote: I was wondering if it is possible to add to this formula, if all cell values are blank than formula returns, blank. Current Formula in AB2 =IF(W2="Unknown","Unknown",MAX(X2,SUM(Y2:AA2))) W2 - this cell may have a text value of "Unknown", if so cell value in AB2 would return "Unknown", if not than look at X2 (numeric) and determines if that value is greater than the sum of Y2:AA2 (all numeric), and returns which is greater. I need to have it return blank of W2 through AA2 have no values. Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Data Validation/Lookup function does function correcty | Excel Worksheet Functions | |||
copy of excel file not showing formulal/function in the function b | Excel Discussion (Misc queries) | |||
LINKEDRANGE function - a complement to the PULL function (for getting values from a closed workbook) | Excel Worksheet Functions | |||
Offset function with nested match function not finding host ss. | Excel Worksheet Functions | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions |