P-Dub
01-15-2009, 06:44 AM
Okay, i know this forum rocks for hardware, and having seen some of the stuff in this forum, i think i might be on to a winner with someone who can actually help me.
I have been given the task of trying to sort out an Excel spreadsheet, unfortunatley i cannot put it on here because of the nature of the company i work for, but if you guys could take a look at the code i'm trying to work, and let me know why it isnt working i would really appreciate it.
Basically, i'm trying to get a formula to check 2 cells are the same and if they are, via a simple IF statement print either nothing, or a zero as follows...
=IF(A1=B1,IF(C2="Y","0",""),"")
The output needs to be a number, but even removing the quotation marks and putting it is as follows
=IF(A1=B1,IF(C2="Y",0,""),"")
Doesnt seem to get it to work, it always returns FALSE, which i dont think it should do, i think i've narrowed it down to the comparison (A1=B1) not being right, but i'm a little confused as to what i'm supposed to use instead.
Basically, i'm stumped, i've been dumped with this job mainly because i'm the only remotley IT'ish person here ("You play computer games and build them? Here design us a new working spreadsheet") and tbh, they didnt listen when i told them i dont normally do Excel.
If anyone can help, i would be very appreciative.
Dubz
I have been given the task of trying to sort out an Excel spreadsheet, unfortunatley i cannot put it on here because of the nature of the company i work for, but if you guys could take a look at the code i'm trying to work, and let me know why it isnt working i would really appreciate it.
Basically, i'm trying to get a formula to check 2 cells are the same and if they are, via a simple IF statement print either nothing, or a zero as follows...
=IF(A1=B1,IF(C2="Y","0",""),"")
The output needs to be a number, but even removing the quotation marks and putting it is as follows
=IF(A1=B1,IF(C2="Y",0,""),"")
Doesnt seem to get it to work, it always returns FALSE, which i dont think it should do, i think i've narrowed it down to the comparison (A1=B1) not being right, but i'm a little confused as to what i'm supposed to use instead.
Basically, i'm stumped, i've been dumped with this job mainly because i'm the only remotley IT'ish person here ("You play computer games and build them? Here design us a new working spreadsheet") and tbh, they didnt listen when i told them i dont normally do Excel.
If anyone can help, i would be very appreciative.
Dubz