kiwicanta7
New Member
- Joined
- May 3, 2021
- Messages
- 15
- Office Version
- 2016
- Platform
- Windows
Hello All!
So I have cells that may or may not have user inputs that would determine how many returns are provided. The statements basically go down the list to determine if the 25th slot is filled out and if not checks if the 24th slot is filled out etc. If the 25th slot is filled out it provides the relevant information in E3 for all 25 slots, if only 24 slots are filled out F3 provides the correct information then etc. Using the code below (though done 25 times in my code) I'm trying to get it to only spit out the relevant information if that cell is not blank. Any ideas why it is outputting all 25 slots regardless of if there is any input in the cell?
=IF(AND('START HERE'!B198<>""),E3,
IF(AND('START HERE'!B194<>""),F3,
IF(AND('START HERE'!B190<>""),G3,
IF(AND('START HERE'!B186<>""),H3,
etc.
Thank you for the help!
So I have cells that may or may not have user inputs that would determine how many returns are provided. The statements basically go down the list to determine if the 25th slot is filled out and if not checks if the 24th slot is filled out etc. If the 25th slot is filled out it provides the relevant information in E3 for all 25 slots, if only 24 slots are filled out F3 provides the correct information then etc. Using the code below (though done 25 times in my code) I'm trying to get it to only spit out the relevant information if that cell is not blank. Any ideas why it is outputting all 25 slots regardless of if there is any input in the cell?
=IF(AND('START HERE'!B198<>""),E3,
IF(AND('START HERE'!B194<>""),F3,
IF(AND('START HERE'!B190<>""),G3,
IF(AND('START HERE'!B186<>""),H3,
etc.
Thank you for the help!