Ok I have cell A1 & E1 only either 1 will be empty
I want current cell to say if A1 is school, if E1 is empty not at home
but I don't know which will be empty I want to check for both
only 1 will be empty both won't be empty so don't worry
Thanks alot
something like this?
=IF(A1="","School","Not At Home")
the conditions were not really clear, maybe a few example senarios?
If you liked my solution, please click on the Star -- to add to my reputation
If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.
=OR(IF(D231="", A231 & " not in SCHOOL",""),IF(A231="",D231 & " not in HOME",""))
this is not working
try it like this, its actualy a nested if, not an or condition
=IF(D231="", A231 & " not in SCHOOL",IF(A231="",D231 & " not in HOME",""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks