I don't understanding this formula

[kulasekhar]

Hi All,

formula: =if(isblank(User_Provided_Rate);Historic_Rate_Win_Close;User_Provided_Rate)

I have Rate Fields:  [Attach Win Rate],

                               [Attach Close Rate],

                               [Annuity Win Rate],

                                [Annuity Close Rate],

                                [New Win Rate],

                                [New Close Rate],

                                 [Consulting Win Rate],

                                 [Consulting Close Rate]

Win Rate mean sing the contract(Win Rate = sing the contract)

Close Rate mean deal close(Close Rate = deal close)

What can i do.

Thanks

sekhar.

[sunny_talwar]

formula: =if(isblank(User_Provided_Rate);Historic_Rate_Win_Close;User_Provided_Rate)

Slight Edit to your formula here:

=If(Len(Trim(User_Provided_Rate)) = 0, Historic_Rate_Win_Close, User_Provided_Rate)

The above formula just means that if User_Provided_Rate is not provided (in other words blank or null), then use Historic_Rate_Win_Close, otherwise just use what is available for User_Provided_Rate

[vvvvvvizard]

its  =if(isnull(field),'value',field) as fieldname,