Forum Discussion
Michael1105
Nov 01, 2019Brass Contributor
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
- TwifooSilver ContributorTry this:
=IF(D29<>””,”V”,
IF(D30<>””,”1st”,
IF(D31<>””,”2nd”,
IF(D32<>””,”F”,
“”))))- Michael1105Brass Contributor
Twifoo Thank you!!! worked!
- TwifooSilver ContributorYou’re welcome!