Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with conditional formula
Hi All
I am using the following formula =IF(K49=0,MIN(K4:K38),LOOKUP(MAX(J4:J38),K4:K38)) with this formula if K49 is not equal to 0 and there is no value in J4:J48 and K4:K48 It returns a #NA . For the most part this is not a functional problem but more of an asthetic issue. What can I add to this formula to get it to return a Blank cell if there is no value in J4:J48 and K4:K48. This will tidy up my sheet and make it look much nicer Thanks Dan N crunchnin numbers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formula to indicate Formula in cell | New Users to Excel | |||
A little help with a conditional formula, please. | Excel Worksheet Functions | |||
Conditional Formula | Excel Worksheet Functions | |||
Help with a conditional formula | Excel Worksheet Functions | |||
Formula for conditional "ifs"? | New Users to Excel |