Ian_M - profile

Ian_M · Apr 16, 2020

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

Ian_M · Apr 16, 2020

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

Ian_M · Apr 16, 2020

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

User Statistics

User Activity

Formula for displaying $ value and an existing cell value

Re: Formula for displaying $ value and an existing cell value

Re: Formula for displaying $ value and an existing cell value