#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
if(and(N3=0,Q3=0,T3=0,W3=0,Z3=0,AC=0,AF=0),"FC","N C")
|
#3
|
|||
|
|||
Thank you. That is what I done in the first place, but I have just tried it again and I'm getting "#NAME?" appear instead. It's not liking something
|
#4
|
|||
|
|||
Just tried again. I did have to amend the above formula to show as AC3 rather than just AC.
It did not show "#NAME?" this time. But showed "NC" which is strange as all the cells mentioned in the formula have the value of 0, so it should be showing "FC". |
#5
|
||||
|
||||
Please post a sample sheet ( no pics please) Thx
(also AF3 instead of AF in Alan's answer)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#6
|
||||
|
||||
Thanks for the correction Pepe. Air code/formulas are not always trustworthy.
|
#7
|
||||
|
||||
No worries Alan, I've already learned so much from you I thought it time to do something back
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#8
|
|||
|
|||
I have attached a rough copy of the template I currently have set up. I have removed some columns and information, so the cells in the formula are slightly different than mentioned in previous replies.
The current formula is - =IF(AND(M3="0",P3="0",S3="0",V3="0",Y3="0",AB3="0" ,AE3="0"),"FC","NC") I only need it to apply for the "Remaining" columns for the column numbers highlighted in blue (you'll see what I mean) |
#9
|
||||
|
||||
Your mistake is confusing "0" and 0.
All strings between double quotes are text, the rest is number As there are no text strings 0 you always get NC Your values in col M, etc are numbers This is obscured by the fact that you applied manual alignment probably for cosmetic reasons You should avoid that when building your sheet, and only apply it on the finished product Why ? Text is always left aligned in a cell and numbers always right-aligned. This feature helps finding mistakes
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting a Select statement in Excel to an update statement | shabbaranks | Excel Programming | 5 | 10-31-2018 11:47 PM |
IF statement | mrry475 | Excel | 1 | 09-06-2016 09:30 AM |
Need a little help with an if statement | cangelis | Excel | 2 | 04-08-2015 05:55 PM |
IF Statement | teza2k06 | Excel | 1 | 03-11-2015 12:44 AM |
Need help with If, Then Statement Please | cangelis | Excel | 4 | 01-03-2014 09:10 AM |