Forum Discussion
Excel...simple formula not working
I have the Family Office 365 version, so not the Primary holder yet expect Excel to work. I create a number in cell e51; ans 5 I create a number in f51; ans 10. Both from either Find or Len functi...
Did check that...and Yes it is
- https://1drv.ms/x/s!ApvNP5zxc9GNgijrXnYeBD_l5UQz?e=8Xhe0W
Thanks! Your formula in G52 refer to cells in row 51, but the cells you want are in row 52:
Since E51 and F51 are blank, your formula =IF(E51=0,0,RIGHT(B51,(F51-E51))) returns 0.
If you refer to E52 and F52, you get the desired result:
- OMG...rookie mistake...yet at my age maybe not....I was looking to write formulas to switch names around...so Bill Ellis would be Ellis, Bill and Greg Cebry would be Cebry, Greg....so when ran the formulas and it showed 5, and 10 I presumed correct ...yet both names in both Rows yield same result..so it was my eyesight thinking I was writing formulas in Row 51 when I was in 52....uugghh....Sorry for wasting your time...and thank you for at least finding my issue...as I was beginning to think I was going 'mad'.
- Thank you for looking into this right away....I have never done this Help system before and never used OneDrive before....but have used Excel extensively, to a point, and am overly frustrated the way Microsoft seems to have tightened control over the application experience....like buying a tool in a store, say a hammer, and then needing someone else to hold the handle with you when you hit a nail....bloody ridiculous.
