Thread: [Solved] IF Statement (again)
View Single Post
 
Old 02-09-2022, 01:30 PM
teza2k06 teza2k06 is offline Windows 10 Office 2010 32bit
Advanced Beginner
  
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default IF Statement (again)
Hi All,
Unfortunately I am stuck on what seems to be a simple formula (in my head), but I can't seem to get it working... surprise surprise .

So in "A3" I want an IF Statement which shows "FC", if cells N3,Q3,T3,W3,Z3,AC3,AF3 all equal 0 (there is currently a formula in these cells giving me a remaining total of 2 other cells). If not all of the above equal 0 (e.g. one of the 7 cells shows "2", then I want the cell "A3" to say "NC".

Any help would be much appreciated as always.

Thanks all
Reply With Quote