Here's the formula I've entered: =IF(AND(ISBLANK(F2),(NOT(ISBLANK(G2)))),CONCATENATE(B2," - ",G2," pcs/box")),IF(AND(ISBLANK(G2),(NOT(ISBLANK(F2)))),CONCATENATE(B2," - ",F2," sf/box")),IF(AND(NOT(ISBLANK(F2), (NOT(ISBLANK(G2)))),CONCATENATE(B2," - ",F2," sf/box - ",G2," pcs/box")),"")
This is to format a spreadsheet to concatenate fields and text depending on whether fields do or do not have data. I've included "" at the end for the final else. Excel is telling me that I've entered too many arguments for this function. One that is simpler (where I only have one if, then an else) is working. But there are times when I need to check for additional empty fields. (Or cells) So, the first IF would give the tile name(B2) - #(G2) pcs/box. The second IF would give the tile name(B2) - #(F2) sf/box. The third IF would give the tile name(B2) - #(F@) sf/box - #G2) pcs/box. The final "" would give a blank. I hope you can help. I've looked everywhere. I'm stumped. I've looked at the () to make sure they're matched.
Aucun commentaire:
Enregistrer un commentaire