By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,462 Members | 785 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,462 IT Pros & Developers. It's quick & easy.

IIF Data Return Type.

P: 3
I need help in putting this IIf function to come out as text:

=IIf([Hourly]>0,([Hourly]*40)-(([Hourly]*40)*0.3),([Salary]/52)-(([Salary]/52)*0.3))

Any ideas?
May 8 '07 #1
Share this Question
Share on Google+
6 Replies


Rabbit
Expert Mod 10K+
P: 12,365
Why does it need to come out as text?
May 8 '07 #2

P: 3
Its for a project in school, and I need help figuring out how to make it come out as text
May 8 '07 #3

Rabbit
Expert Mod 10K+
P: 12,365
Its for a project in school, and I need help figuring out how to make it come out as text
You'll want to take a look at the conversion functions.
May 9 '07 #4

P: 3
What conversion function would make it come out as text?
May 10 '07 #5

Rabbit
Expert Mod 10K+
P: 12,365
Type Conversion Functions
It says 2007 but it works for 2003 as well.
May 10 '07 #6

NeoPa
Expert Mod 15k+
P: 31,476
What conversion function would make it come out as text?
You need to look and find that out for yourself.
We have a policy when dealing with assignments that precludes simply giving answers ready made. If truth be told, even an adult looking for help would be expected to find that out for himself with the pointers already given.
May 10 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.