Do a favour please. Its about if function
Closed
Ali
-
Jan 11, 2011 at 07:45 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 19, 2011 at 09:29 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jan 19, 2011 at 09:29 AM
Related:
- Do a favour please. Its about if function
- Find function on mac - Guide
- Accessor function c++ - Guide
- Spreadsheet function - Guide
- Agp function - Guide
- Hard drive function - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jan 19, 2011 at 09:29 AM
Jan 19, 2011 at 09:29 AM
you need to write a user defined function to handle that
Not sure if your if statement was correct, as B3>2000 appears before B3>6500.
Assuming you if statement is not correct, this is a sample function. you would call if like
=myLousyIF(b3)
Not sure if your if statement was correct, as B3>2000 appears before B3>6500.
Assuming you if statement is not correct, this is a sample function. you would call if like
=myLousyIF(b3)
Public Function myLousyIF(myCell As Range) As String
Select Case myCell.Value
Case Is > 7500
myLousyIF = "6.5%"
Case Is > 6500
myLousyIF = "5.5%"
Case Is > 5500
myLousyIF = "4.5%"
Case 4500
myLousyIF = "3.5%"
Case Is > 3500
myLousyIF = "2.5%"
Case Is > 3000
myLousyIF = "1.5%"
Case Is > 2500
myLousyIF = ".75%"
Case Is > 2000
myLousyIF = ".5%"
Case Else
myLousyIF = "0"
End Select
End Function
