|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
February 4th, 2010, 04:02 PM
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
February 4th, 2010, 04:33 PM
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
