SOLVED

formula help

Copper Contributor

Hi

I have a spreadsheet with people who pay membership rate and guest rate

I'm trying to create a formula for the member/ guest rate column where

if  (amount)= $325, then "GUEST"

or if (amount) = 276.25, then "MEMBER"

any other (amount) the field should remain blank.

 

What formula should I use in the member/guest rate column to make this work?

thanks, Melanie

AccountClrAmountmember/ guest rate
4000-40 Live Study Income:Tuition - Advanced Classes 276.25 #VALUE!
4000-99 Live Study Income:Tuition - Discounts -176.25 FALSE
4000-99 Live Study Income:Tuition - Discounts -25.00 FALSE
4000-10 Live Study Income:Tuition - Foundations 150.00 FALSE
4000-10 Live Study Income:Tuition - Foundations 276.25 FALSE
4000-20 Live Study Income:Tuition - Inner Transformation 276.25 FALSE
4000-99 Live Study Income:Tuition - Discounts -48.75 FALSE
4000-40 Live Study Income:Tuition - Advanced Classes 276.25 FALSE
4000-40 Live Study Income:Tuition - Advanced Classes 325.00 #VALUE!
4000-40 Live Study Income:Tuition - Advanced Classes 325.00 guest
3 Replies
best response confirmed by mgruenwald (Copper Contributor)
Solution

@mgruenwald 

Perhaps you mean

= IF(amount = 325, "GUEST", IF( amount = 276.25, "MEMBER", "") )
got it thanks!

@mgruenwald , you are welcome

1 best response

Accepted Solutions
best response confirmed by mgruenwald (Copper Contributor)
Solution

@mgruenwald 

Perhaps you mean

= IF(amount = 325, "GUEST", IF( amount = 276.25, "MEMBER", "") )

View solution in original post