I'm having problems with an If statement that will not execute. The same function works fine when I copy-paste it to an other cell, but it simply does not work for the cell that I want. Anyone who's had the same problem?
Here is my function:
=HVIS(Inngangsdata!C5=0;"";Inngangsdata!C5)
('Hvis' is 'if' in norwegian, 'Inngangsdata' is just the name of the page from which cell C5 is taken).
Check the formatting of both C5 and the cell with the formula are they the same?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Haha! and I who thought that I had tried everything... You were right, the format was not the same.. Thanks a lot!
Glad to help - thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks