How can I create a formula to take greater of award value or modified value - cost.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I need to create a formula that should give me profit.

I have award value and modified award value(sometimes we go back o=to the customer for change of price)

The formula needs to be Greater of Award Value or Modifeid award value minus total cost .

Can someone please help...


Photo of Neal


  • 0 Points

Posted 3 years ago

  • 0
  • 1
no problem

Max([award value], [modified award value])