=IF(C23="",(""),(K42))
=IF(C24&C23="",(K42))
what i am trying to get it to do is if c23 is blank or cells c23 and C24 are blank K42
Thanks
=IF(C23="",(""),(K42))
=IF(C24&C23="",(K42))
what i am trying to get it to do is if c23 is blank or cells c23 and C24 are blank K42
Thanks
So you're basically saying if C23 is blank, then K42. C24 doesn't matter whether it's blank or not based on what you are saying, so the equation would be:
=IF(C23="",K42,"")
OR, based on your first equation, are you actually saying, IF C23 is NOT blank, OR, if C23 and C24 are blank, then K42. If this is the case, then one way of writing it would be:
=IF(AND(C23="",C24=""),K42,IF(C23<>"",K42,""))
Maybe?
=IF(C24&C23="",K42,IF(C23="","",K42))
Last edited by Phuocam; 02-09-2020 at 12:53 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks