simpler

I need an IF statement that keys off grades of C- to A+. Something like this: IF(B1>="C-",A1,""). I know that statement doesn't work, while using a series of OR statements does, but I wondered if there was something simpler than the OR statement approach which uses 9 substatements, e.g...

Hi Is there a simpler & neater way to write this in a For Each loop With Sheet3.Shapes .Range("Picture 7").Visible = msoFalse .Range("Picture 9").Visible = msoFalse .Range("Picture 4").Visible = msoFalse .Range("Picture 5").Visible = msoFalse .Range("Picture 6").Visible...

An Internet search turned up this expression for obtaining the name of the active sheet. =MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,255) It seems to work, but is there really nothing simpler and more straightforward?

Hi All and HNY2019 Is there simpler and cleaner way to code this to make the Status Bar appear to flash? Sub StatusFlash() Do Until c > 5 Application.StatusBar = "Setting up - " Application.Wait (Now + TimeValue("00:00:1")) Application.StatusBar = "Setting up -...

Hi, I got this formula idea from an old thread here. I successfully got the formula to work, but it's very slow. Is there a simpler process? =IF(A2="","",SUMPRODUCT(SUBTOTAL(9,OFFSET('Partner Planner'!C2,ROW('Partner Planner'!$C:$C)-ROW('Partner Planner'!C2),0)),('Partner...

Hi (again) I am sure this is something to do with array or range, but i cannot get my head around it. There must be a simpler way to express the "if(or(" part of the following formula (in red)...

Excel 2016 I have 12 columns with values in (example row - FU3:GF3) I want cell FT3 to check if 'any' cell in the row of 12 has a negative value then result with "Minus" Instead of having to type 12 IF conditions, is there a simpler option? Thanks

Hi Any idea as to how this can re-written so it can be simpler and calculate faster...

For my model I have constants to be applied such as projected inflation rate, depreciation years, and other values to be set by users as what-if options. There are too many variations the users want to create disconnected tables - e.g. listing every inflation rate by hundredths of a percent -...

I have 7 codes that I need to convert to their corresponding value. I want to do this using IF, but felt nesting 7 of them is a bit excessive. I recall once getting a tip on how to put them all in one but can't seem to find it...unless I'm remembering wrong. It can be done can't it? I...

Is there a simpler way of writing this IF statement? =IF(MONTH(B3)=7,11,IF(MONTH(B3)=8,10,IF(MONTH(B3)=9,9,IF(MONTH(B3)=10,8,IF(MONTH(B3)=11,7,IF(MONTH(B3)=12,6,IF(MONTH(B3)=1,5,IF(MONTH(B3)=2,4,IF(MONTH(B3)=3,3,IF(MONTH(B3)=4,2,IF(MONTH(B3)=5,1))))))))))) Thank you!

Hi there, in cell E6 I have this formula -...