Forum Discussion
Splitting cell values
- Jan 28, 2024
Thanks heaps. it works for the No value in F and almost works for The Yes. It seems to miss the fact we can't claim for the amount over 200. Although it does looks like that is in the formula??
Would it be easier to do add some extra column and the remove the unit amount if F = no? (F = O in the example below)
Thanks heaps. it works for the No value in F and almost works for The Yes. It seems to miss the fact we can't claim for the amount over 200. Although it does looks like that is in the formula??
Would it be easier to do add some extra column and the remove the unit amount if F = no? (F = O in the example below)
Andy1883 The results of the IFS function in column H of your screenshot appear to be correct. Double-check your formulas in column I (Claimable Distance). The formula in cell I13 should be =G13-H13 (212-62=150), and the formula in cell I16 should be =G16-H16 (207-57=150).
- Andy1883Jan 30, 2024Copper ContributorAwesome thank you.
Column I was wrong.
works perfectly now- djclementsJan 30, 2024Bronze ContributorYou're very welcome. Cheers! 🙂