Latest activity
-
Ssiriusjewelers updated their status.Explore beautiful mangalsutra designs for women in modern and traditional styles. Find elegant gold and diamond designs for daily wear...
-
Aalexiaamber replied to the thread Number of text cells by color.Hi Dave, Yes, this can be done with VBA, but the important point is that Excel’s normal COUNTIF/COUNTIFS functions don’t directly count...
-
shamimarita replied to the thread nested if statement.Hello Wandy, You can combine Annual Check and Monthly Check using the OR function, since both use the same conditions for the date in... -
shamimarita replied to the thread Calculation based on lookup values.Hi snowbunny99, You can handle the duplicate PO# rows by allocating the received quantity to each ordered row sequentially instead of...
-
shamimarita replied to the thread Comparing percentage values against constants, less than, greater than, and ranges.Hello bevtyler, Yes, you can simplify this quite a bit instead of continuing with multiple nested IF statements. If the criteria are in...
-
Bbevtyler posted the thread Comparing percentage values against constants, less than, greater than, and ranges in Excel Formulas.I have two small tables where I need to compare percentages in columns E, F, G to the values/ranges in A, B, C. Is there an easier way...
-
-
SHi everyone, Could you please help me with a formula to calculate the Outstanding Qty in column D? There are 2 tables: the left one is...
-
-
Wi have this issue if (C2="annual check") { if (D2<TODAY() print expired; else if (D2<=TODAY()+7 print expiring soon; else print...
