| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help to Modify these guys
I need these three functions which work well to not display any thing or ""
if there is no data to calculate against.: ========== =IF(AND(H18=4.5),0,H18-$I$2) =IF(AND(H3<=5.5),0,H3-$J$2) =IF(AND(I3=0,J3=0),"Pass","Fail") ========== Can some one show me how to modify these three functions to not show any value if there is no data in the refferenced fields? If there is, HOW? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hi Guys. First Time Poster | Excel Discussion (Misc queries) | |||
| Hi Guys. First Time Poster | Excel Worksheet Functions | |||
| How do I modify an existing worksheet to remove columns & contents | Excel Discussion (Misc queries) | |||
| Modify Date Changes when NOT saving | Excel Discussion (Misc queries) | |||
| Modify SUMIF and COUNTIF to work with SUBTOTALS | Excel Worksheet Functions | |||
Threaded Mode
