I am aware that you can evaluate two cells for equality using "double equal
signs" -- for example, by entering "=A1=B1" into cell C1 to test cells A1 and
B1 for equality. Is there a way to use this "double equal signs" approach in
place of an IF statement?
More specifically, is it possible to create a formula such as "=A1=B1
AVERAGE(1,2) "NA""? I have seen a formula such as this that did not include
commas between parameters -- any help on this front will be greatly
appreciated.
Bookmarks