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]...
