Forum Discussion
Splitting cell values
Hi Guys This will be easy for someone I am sure but my brain is checking out. need to copy the value of G to H if F is no. if F is Yes then need minus 50 from it and put it in I. If I ...
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).
Awesome thank you.
Column I was wrong.
works perfectly now
Column I was wrong.
works perfectly now
- You're very welcome. Cheers! 🙂
