Looking for a help with formula

[mlozovskaya]

Please help to figure out what formula to use for desired output

[atcodedog05 · Accepted solution]

Hi @mlozovskaya 

Here is how you can do it.

Formula:

IF [Date1]>=[Date2] THEN [Date1Price]*[#]
ELSE [Date2Price]*[#] ENDIF

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @mlozovskaya 

Cheers and have a nice day!