Need help in logical function

[Rahul Verma]

I have a question, calculate DA 60 % on Basic pay or 3000 whichever is higher .
Which if condition is apply....?

[#2]

Rahul,

I don't know what DA means but I guess you are looking for this:

=MAX(3000.Basic_pay*60%)

[#3]

Hi @Rahul Verma,

Put formula. That will show which is higher. I've taken 10000 as your Basic Pay.

=MAX(10000*60%,3000)