I have this formula which works great:
=IF([@[payment method]]="paypal";"y";"n")
but i want to update it to show also "Y" if @[payment method]] there is "paypal" and also "visa" for example.
I have this formula which works great:
=IF([@[payment method]]="paypal";"y";"n")
but i want to update it to show also "Y" if @[payment method]] there is "paypal" and also "visa" for example.
Try
=IF(OR([@[payment method]]="paypal";[@[payment method]]="Visa");"y";"n")
Do these work?
=IF([@[payment method]]="paypal";"y";IF([@[payment method]]="visa";"y";"n"))
or maybe
=IF(OR([@[payment method]]="paypal";[@[payment method]]="visa");"y";"n")
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Thank you guys.
reputation given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks