SharePoint Custom List, 3 fields to get one

I have three fields in my sharepoint list

field_est
field
field_actual

if field <> "" then field_actual = field
else
field_actual = field_est

How can this be done with a calculated field?
Matt PinkstonAsked:
Who is Participating?
 
manuj_nagpalConnect With a Mentor Commented:
This can be done via below formula :
=IF(field<>"",field,field_est)

More Info : http://msdn.microsoft.com/en-us/library/bb862071.aspx
0
All Courses

From novice to tech pro — start learning today.