How to know if I'm using the right data type?

[Asdf0qwerty]

Hi everyone,

I'm using the Currency data type in my current User Defined Function(UDF) Add-In in Excel 2007 VBA to handle monetary values (e.g. salaries). My questions are:

1. So is the Currency data type the BEST data type for handling All monetary values this and if so, why?

2. What are the BEST practices or ways to Know / Test if I'm using the right data type for my variables?

Hope you can help me out. TIA.

 

[sulakvea]

currency is pretty safe to use - it is stored just like the way you see it, as an equal number (unlike, say, date). so $100+$200 = $300

and yes, i normally use currency data type for analyzing sales, etc.

but - i'm just a sample of one.

 

[Asdf0qwerty]

@sulakvea: okay got that ''D I've done some additional research as well. You are right! Thanks for affirming and GBY "D