Forum Discussion
Error in my formula
I have a shared excel document but for some reason only on mine this specific formal isn't working - I have tried everything that google has told me.
the formula is to help track deliveries and estimate when then lorries will be arriving - but it doesn't seem to like my computer or excel I'm not sure.
this is the formula
=IF(RC[-1]="", "", IFERROR(MINIFS(R3C21:R93C21, R3C21:R93C21, ">=" & RC[-1]), ""))
2 Replies
There are several possible causes:
This formula uses R1C1 notation. If you use A1 notation, the formula will not be recognized.
To switch, select File > Options > Formulas and tick the check box R1C1 reference style.
If you use comma as decimal separator, replace the commas in the formula with semicolons ;
The MINIFS function was introduced in Excel 2019. If you have an older version, it will not be recognized.
- Thank you - it is now working 🙂
