Solved: Excel VBA question

sk0101 · 09-Feb-2010, 12:29 PM #1

HI have a formula that looks at a tab and displays the data in a different tab (Data Tab).

Could you please tell me why it is not working, when I open the excel file?

Also, why cant I modify the formula?

Attached a file.

Thank you,

slurpee55 · 09-Feb-2010, 12:53 PM #2

First, you must change the cell with the formula in it from Text format to General.
Then change your formula to:
=IF(VALUE(ECCnetData!B3)=1,IF(VALUE(ECCnetData!E3)<>"",ECCnetData!E3,""),IF (VALUE(ECCnetData!B103)=2,IF(VALUE(ECCnetData!E103)<>"",ECCnetData!E103,"") ,IF(VALUE(ECCnetData!B104)=4,IF(VALUE(ECCnetData!E104)<>"",ECCnetData!E104, ""),"")))
The VALUE() allows for the fact that the numbers on the sheet ECCnetData are formatted as text, and finds their numeric value.

sk0101 · 09-Feb-2010, 01:06 PM #3

Thank you for your help.

slurpee55 · 09-Feb-2010, 01:19 PM #4

No problem - an interesting problem, too!

Tag Cloud
access acer asus bios bsod computer crash desktop drive driver drivers error ethernet excel freeze gaming hard drive hardware hdmi internet laptop malware memory missing monitor motherboard network printer problem ram random registry router slow software sound trojan ubuntu 11.10 uninstall usb video virus vista wifi windows windows 7 windows 7 32 bit windows 7 64 bit windows xp wireless

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Search
Search for:

Find the solution to yourcomputer problem!

Find the solution to your
computer problem!