Len Funtion
Apr 25, 2006 Range("A1:F50").select
If Len(Cells.value) > 40 Then
activecell.clearcontents
End If
ADVERTISEMENT
Countif Funtion For More Than One IF
Mar 30, 2009If I have column A with a department name e.g. A, B, C, etc
and
column B with a date next to the some of the entries of column A.
How would I compose a formula to return an answer of the amount of records that show column A as "A" and column B as "1".
This is probably immensely simple and I have a wet fish on standby to hit myself with.
If Funtion Is Not Working When Comparing ROI
Sep 11, 2009I created a spreadsheet to calculate property "Return on Investments" (ROI). I then added a column with the If command. Here is an example formula:
=IF(AND(G12>=G4; G12>=G5; G12>=G6; G12>=G7; G12>=G8; G12>=G9; G12>=G10; G12>=G11; G12>=G13; G12>=G14; G12>=G15; G12>=G16; G12>=G17; G12>=G18; G12>=G19; G12>=G20; G12>=G21; G12>=G22; G12>=G23; G12>=G24; G12>=G25; G12>=G26; G12>=G27; G12>=G28);"Buy!!";"--")
I dont know if it matters but the ROI is a very small decimal percent. However I found that when 2 properties get close the "Buy!" symbol dissapears from all cells. I have compared all the formulas and found no issues.
I have attached the file to this post
The issue occurs when 1750 is but in cell B12. I have narrowed the issue to cells A6 and A10.
=IF(AND(G6>=G4; G6>=G5; G6>=G7; G6>=G8; G6>=G9; G6>=G10; G6>=G11; G6>=G12; G6>=G13; G6>=G14; G6>=G15; G6>=G16; G6>=G17; G6>=G18; G6>=G19; G6>=G20; G6>=G21; G6>=G22; G6>=G23; G6>=G24; G6>=G25; G6>=G26; G6>=G27; G6>=G28); "Buy!!"; "--")..............
ISERROR Funtion Into An IF AND Statement
Sep 23, 2009I am trying to nest an ISERROR funtion into an IF AND statement.
Column B D E F
Cases Case Pack Reg Price VPR Price
1 14 2.25 0.00
1 14 1.75 2.00
When the value of F is zero, I want the formula to be B1*D1*E1, when the value of F is not zero, I want the formula to be F1*D1*B1. I can figure this part out. The problem is I have these values on a certain number of rows and I want a grand total at the bottom, but the rows that do not have values in them are giving me a #VALUE! error, which is messing up the grand total. I am not sure how to write the formula with the IF AND and ISERROR functions.
Sum Product Funtion Within A Date
May 11, 2007I have a column that lists names, and I need to count how many there are for each name, sounds easy enough use the following i think.
=SUMPRODUCT((A1:A10="Joe")
The trick is, I only want it to sum them if it's within the current month. I am entering something wrong because I get an error message.
Auto Chart W/IF Funtion
Feb 2, 2008Chart updates correctly when new pricees added.
But my IF function in column C leaves the annoying line to zero until prices are enter in column B.
Creating SUMIF Funtion
Jun 30, 2009I am looking for the exact code to make a "SUMIF" function so that I can modify it to add another search criteria, such that I only wan the sum if it finds both in the range.
View 9 Replies View RelatedFuntion/Code To Rename A Sheet/tab
Dec 13, 2007Is there a function to do this or only VB code?
View 14 Replies View RelatedHow To Return Value From VBA User Defined Funtion
Nov 26, 2009how to return value from VBA User Defined Funtion
View 9 Replies View RelatedLIST Funtion: Find The Highest Number ?
Jul 30, 2008I have several worksheets where I input data, and I would like a 'stats' page as worksheet 1. Work sheet one is a list of names in cells A4:A28. column B,C,D,E,F, and G contain the results using Countif. How would I now get excel to look down a column, for example B, to find the highest number in that column and then use the name from that line but in column A.
View 3 Replies View RelatedIncorporate Concatenate Funtion: Return Text Rather Than A '0'
Apr 2, 2009I have the following formula: ...................
and excel is saying I used too many characters and to use the concatenate function to do so, but I have no idea how.
I wanted to return text rather than a '0' in the case that all the original IF statements were false, I threw another IF statement in there and said if the original is equal to '0', then return "-". If not, then run through the original again (I pasted the original again after the "-").