If Multiple Criteria

[danieldors]

Hello,

I'm trying to combine the two formulas below into one with no success, any suggestions is appreciated. Thank you.

= if ((phoneNumber > 0), phoneNumber,
if ((phoneNumber = 0), 'No Phone', 'No Phone'))

= if (( CellPhone > 0), CellPhone,
if (( CellPhone = 0), 'No Phone', 'No Phone'))

[MayilVahanan]

HI Daniel

May be , try like below

If(PhoneNumber > 0, PhoneNumber, 

If(CellPhone > 0, CellPhone, 'No Phone'))

Hope if phonenumber is there, we don't need to consider CellPhone info..