Help with IF function

Charlie · Mar 27th, 2002, 04:09 PM

Hi, I have a column of data containing the values, "Paid in Full" "Unpaid" and "Underpaid", I am looking for a formula that will place 0% in the next column if the data is either paid in full or underpaid, and 6% if the data is unpaid.This value is to be added as an extra charge for non payment.
Thanks
Charlie

BabyTiger · Mar 27th, 2002, 04:13 PM

Hi,

Assuming the data column contains "Paid in Full", and so on, is you column A, then formula is inserted in column B:

=if(or(a1="Paid in Full",a1="Underpaid"),0%,if(a1="Unpaid",6%,"N/A"))

HTH

Ian Mac · Mar 27th, 2002, 04:17 PM

Quote:

On 2002-03-27 15:09, Charlie wrote:
Hi, I have a column of data containing the values, "Paid in Full" "Unpaid" and "Underpaid", I am looking for a formula that will place 0% in the next column if the data is either paid in full or underpaid, and 6% if the data is unpaid.This value is to be added as an extra charge for non payment.
Thanks
Charlie

Assuming your list is in A1 down, use:

=IF(OR(A1={"Paid in Full","Underpaid"}),0%,6%)

change the format to Percentage

Charlie · Mar 27th, 2002, 04:19 PM

Thats great, it worked a treat.
thanks
Charlie

Aladin Akyurek · Mar 27th, 2002, 04:22 PM

=(A1={"Paid in Full","Underpaid"})*0%+(A1="Unpaid")*6%

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 27th, 2002, 04:09 PM	#1
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Hi, I have a column of data containing the values, "Paid in Full" "Unpaid" and "Underpaid", I am looking for a formula that will place 0% in the next column if the data is either paid in full or underpaid, and 6% if the data is unpaid.This value is to be added as an extra charge for non payment. Thanks Charlie

Mar 27th, 2002, 04:13 PM	#2
BabyTiger Board Regular Join Date: Mar 2002 Location: Wellington Posts: 104	Hi, Assuming the data column contains "Paid in Full", and so on, is you column A, then formula is inserted in column B: =if(or(a1="Paid in Full",a1="Underpaid"),0%,if(a1="Unpaid",6%,"N/A")) HTH

Mar 27th, 2002, 04:19 PM	#4
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Thats great, it worked a treat. thanks Charlie

Mar 27th, 2002, 04:22 PM	#5
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,319	=(A1={"Paid in Full","Underpaid"})0%+(A1="Unpaid")6%