SOLVED
Home

Ignore number in list

Highlighted
Mike_Cook
Occasional Contributor

In this spreadsheet the user enters a number called customer reading 

Then they enter a series of numbers, at some point they will enter a number that is lower than the customer reading, in the attached spreadsheet it works ok but if they enter two numbers that are lower it miscalculates . you can see this on the two tabs .I think the issue is with J4 

3 Replies
Highlighted
Solution

Hello Mike, 

In the attached file, I removed the unnecessary SUM functions. Also, I modified the formulas in these cells: 

J4=INDEX(D12:D22,
MATCH(J3,D12:D22,-1)+1)

E12=IF(D12>D$5,
E13+J$7,
D12)

Hopefully, this version will ultimately resolve your issues. 

Cheers!

Twifoo

Highlighted

Thank you 

Welcome!
Related Conversations
SharePoint 2013 LIst Filters (by latest date)
dmphil in SharePoint on
0 Replies
SharePoint Lists - Expanded View Roadmap ID: 57302
Kotus-Tech in SharePoint on
10 Replies
Multi-value fields display no separator
Florian Hein in SharePoint on
1 Replies
SharePoint List Drag item Move error
mvas111 in SharePoint on
0 Replies
SPO list jumps to top when loading new items
ABehrens in SharePoint Developer on
1 Replies