Forum Discussion
Return values from some cells if other cells meet criteria
I am trying to return a list of computer names and possibly Windows build version and memory available if build version is less than X and memory is less than X. So ideally on Sheet 1 (Overv...
- So I only want to return values if the "Memory" and "Build" columns meet the criteria.
I don't what lines that say "No Problem".What should the formula return if the build is 19042 or higher? Reimage? If so:
IF(AND(C4<19042,D4<15*1024),"Replace","Reimage")
