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 functions which both gave the correct result. I checked to ensure the results were both numbers with ISText function. Then just put a simple formula in = f51 - e51 and got 0....Zero!!??? what the heck is going on??? When I put the formula =IF(E51=0,0,RIGHT(B51,(F51-E51))) I got 0, even though e51 is 5 so what the heck is going on with Excel....unreliable now?
9 Replies
- How do I attach a sample file here??
That could be available in the editor when you reply on the post
If not when share on OneDrive, Google Drive, whatever, make available for everyone and share the link.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?
