VBA Tips - Write Your Own Excel Function

Hello,

I have this function
Code:

    
Function FitnessRating(aVal As String, bVal As String) As String
        If aVal = "I would go out for a walk" And bVal = "Yes" Then
            FitnessRating = "10"
        ElseIf aVal = "I would stay in watching TV" And bVal = "No" Then
            FitnessRating = "0"
        ElseIf aVal = "I would go out for a walk" And bVal = "No" Then
            FitnessRating = "5"
        ElseIf aVal = "I would stay in watching TV" And bVal = "Yes" Then
            FitnessRating = "5"
        End If
    End Function

and for what I'm doing I need to be able to write it with Excel's IF function, I'm trying to do it with by nesting them like this,
Code:

=IF(AND(I20="I would go out for a walk", I22="Yes"), "10", IF(AND(I20="I would stay in watching TV", I22="No"), "0"))

but that's as far as I get until I start getting the error "You've entered too many arguments for this function" message . Can anyone help me out here??

Thanks (P.S sorry if this is in the wrong forum)

I have a problem , i want to write a user defined function similar to the SUM() function in Excel. My problem is my decimals should have a base of .24 Once the sum decimal total becomes .24 it should add to the original value by 1.

for eg.
1.11
1.11
1.02
------
4.00 Total
------
total should be 04(i.e add the integers we will have 03 & add the decimals it is .24 which means .24 is 1 so 3+1 = 4


In short instead of the base of .100 which becomes 01 in normal addition the base should be .24

I hope i am able to put my problem across in a correct way.

Please help.

Thanks

I need to write the IF function for two conditions: if a cell value is >2 but
at the same time <4 (between 2 and 4) if true is equal to 4 otherwise if
false is equal to 1. That is I want the cell value if between 2 and 4 to be
equal to 4 and for all other values that are less then 2 and greater than 4
to be equal to 1.

Thank you

Hello,

I have created a user defined function that requires four inputs. The function works perfectly.

The only thing I would like to add is help tips for each input variable.

So like with built in excel functions in the functions box.


eg under hyperlink function:

there is Link_location and Friendly_name when you go into that field the text below changes to explain what that variable is.

Assalam-u-Alaikum (Hello) everyone, please help me in excel 2002, I want to write value jan1 in cell e15,
feb1 in g15, mar1 in i15 than jan2 in e33, feb2 in g33 and mar2 in i33. but when I write jan1 or something
similar excel automatically converts it to number value i want jan1 and other in value is it possible please
help me.

Hello,
We have a user that keeps getting an Write -Delayed Write Failed error. I've tried running all of the office updates for her,restoring the document, saving the document to the desktop first, and saving it back to the network. We also, tried deleting a lot of data to decrease the file size from 4.80MB. None of this worked. Does anyone know how to fix this issue?The only thing I have not tried is to run an excel repair.

What is the easy way to create forms in different sheets.......

In Main Sheet (Sheet1) each row contains some informations about a particular item.
I want to create Forms in separate Sheets and datas for this Form 1 (Sheet2) should be datas of Row#1 of Sheet1 & datas for this Form 2 (Sheet2) should be datas of Row#2 of the Sheet1.......

Hi Guys,
Does anyone know of a web site which offers Excel tips and tricks.
Is there a free book which I can download that will give me tips and tricks.
Thanking you in advance,
Regards

J-O

Hello. I recorded the code below to convert pages of workbook to pdf. It works well on my computer but on a co-worker's computer the pdf produced has header and footer pictures shifted slightly down and to the right, showing small areas of white area on his pdf and I do not see this on my pdf produced.

-Any idea what might cause this situation?
-If I have pictures in the header and footer and the pictures are inserted from my desktop,
does this cause Excel issues with those headers/footers on another computer? Is a better
way to load and link the pictures somewhere in the Excel document?
-Is Excel not the best tool to convert to pdf? Would it be better to use Publisher
or even Powerpoint linked to Excel sheets? How about one of the many Excel to
PDF softwares out there?

Thank you.

Sub convpdf()
Sheets(Array("sheet1", "sheet2", "sheet3", "sheet4", "sheet5")).Select
Sheets("sheet1").Activate
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:= _
"C:\Documents and Settings\myname\Desktop\pdf_file.pdf", Quality:= _
xlQualityHigh, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
OpenAfterPublish:=True
End Sub

Hy guys,

I still work with excel 2007, so, can someone tell me please if the 2010 version shows the formula tips, when we are tipping a formula in the "name manager box", and in the "conditional formating box".(when you use a formula to do conditional formating), like they are shown when we tipe a formula in a spreadsheet cell??
I think that would be a great help