Forum Discussion
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 ...
Try this:
=IF(D29<>””,”V”,
IF(D30<>””,”1st”,
IF(D31<>””,”2nd”,
IF(D32<>””,”F”,
“”))))
=IF(D29<>””,”V”,
IF(D30<>””,”1st”,
IF(D31<>””,”2nd”,
IF(D32<>””,”F”,
“”))))
Twifoo Thank you!!! worked!
- You’re welcome!