My spreadsheet has been compromised

[Grahamfeeley]

Hi I lost my os through a bug, so I reset my oS,
Reinstalled Office 13
Opened up my spreadsheet and soon as I hit any key my formulas change
now my formulas have changed to this
=_xlfn.IFS(G5="","",G5="win",0,G5="loss",I5*(F5-1))
it has placed _xlfn in the formula

question is: HOW do I recover this worksheet with formulas intact ??
any help will be appreciated
Graham

[jindon]

IFS is available from XL2016, so it appears like that in older version.

If you change any cells related that formula it instantly change to "#NAME?" amd you can not recover it.

[AliGW]

Your workbook has not been compromised. The IFS function is not available in Office 2013 - only 2019 and above.

Try this instead:

=IF(G5="","",IF(G5="win",0,IF(G5="loss",I5*(F5-1),"")))

[Grahamfeeley]

Thank you for that I will try tha and thank you indeed
Graham

[AliGW]

Glad to have helped.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.

[Grahamfeeley]

Could you also Please convert this for me also

=_xlfn.IFS(G5="","",G5="win",I5,G5="loss",-L5)
Regards Graham
Looks like this may be all at this stage,

[AliGW]

Please do look at the pattern here and try to do the next one yourself so that you learn.

=IF(G5="","",IF(G5="win",I5,IF(G5="loss",-L5,"")))

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of all those who offered help.