This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi all.
Sure this is super simple and I’m no doubt being super simple myself in not getting the solution…
I have a sheet where I am keeping track on recurring charges. I’m dealing with 3 specific columns in this sheet
Col 1 [$ Charge]
Col 2 [currency...
Hey Mo - realised if I just drop 1 into the FX Rate field, then it’ll solve that problem.
Which actually means I might as well just simplify this and not use IF formula. If I’m going to have the FX Rate field, then I just do a straight multiple Fiel...
Hey Mo! Thanks for your quick reply.
I dropped this in with the new field. It seems to work for the second condition but not quite for the the first.
So with the adjusted fields:
Field 1 ($ Charge) = $1.50
Field 2 [Currency) = AUD
Field 3 [FX Rate]...
