Forum Discussion

Michael1105's avatar
Michael1105
Brass Contributor
Nov 01, 2019

If Is Blank Syntax

Can the If(ISBLANK(cell) syntax be used multiple times for a function?  What I want my worksheet to do is have one cell return data if multiple cells have data inputted into them, if not then return the result as blank.  For example: Cell D33=if(isblank(d29),"","V"),if(isblank(d30),"","1st"),if(isblank(d31),"","2nd"),if(isblank(d32),"","F").  I am getting a "Value" error returned so I am thinking that the reason is because you can't have a string of functions with the IF IS BLANK syntax....

3 Replies

  • Twifoo's avatar
    Twifoo
    Silver Contributor
    Try this:
    =IF(D29<>””,”V”,
    IF(D30<>””,”1st”,
    IF(D31<>””,”2nd”,
    IF(D32<>””,”F”,
    “”))))

Resources