Middlesex County, Ontario | #1 is the most logical way in my mind.
#2 is my preferred way. Instead of showing "FALSE" it will just be an empty cell.
#3 is another way. Nested ifs, if the first condition is true then check the second condition.
The spreadsheet is attached.
Edited by WildBuckwheat 3/2/2022 19:23
 (Excel1 (full).JPG)
 (Excel2 (full).JPG)
 (Excel3 (full).JPG)
Attachments
----------------
 Excel1 (full).JPG (30KB - 155 downloads)
Excel2 (full).JPG (28KB - 155 downloads)
Excel3 (full).JPG (26KB - 159 downloads)
Book1.xlsx (9KB - 155 downloads)
|
Excel and Calc If( problem
