Sum to include sum and also comment

[portcity05]

Hi
I am having trouble with a formula to express a freight cost in the example below under freight.
If the part has a online price as in lines one & two, it needs to read
"FREE" in line one or $49.95 as in line two.
If the part does not have a online price, it needs to read
"ADD" as in line three.

Below is my sum, it leaves $0.00 instead of "FREE" as in line one, this one is beyond my capability.
=IF(C64>1,D64,IF(C64<1,"ADD"))

Hopping someone can help! regards Terry

PART NO

PRICE-F inc

Online price

Online Freight

Online total

Lowest

Freight

<tbody>
</tbody>

EKH355-HP1-57FX	2420.22	2000	0	0	2000.00	$0.00
EKH355-HP1-57X	1962.66	1795	49.95	1844.95	1795.00	$49.95
EKH355-HP1-60	2720.57	0	0	0	2720.57	ADD

<colgroup><col><col><col span="3"><col><col></colgroup><tbody>
</tbody>

 

[Michael M]

Is this what you require

Excel 2007
	A	B	C	D	E	F	G
1	PART NO	PRICE-F inc	Online price	Online Freight	Online total	Lowest	Freight
2
3	EKH355-HP1-57FX	2420.22	2000	0	0	2000	FREE
4	EKH355-HP1-57X	1962.66	1795	49.95	1844.95	1795	49.95
5	EKH355-HP1-60	2720.57	0	0	0	2720.57	ADD
Sheet2

Cell Formulas
Range	Formula
G3	=IF(AND(C3>0,D3=0),"FREE",IF(D3>0,D3,"ADD"))
G4	=IF(AND(C4>0,D4=0),"FREE",IF(D4>0,D4,"ADD"))
G5	=IF(AND(C5>0,D5=0),"FREE",IF(D5>0,D5,"ADD"))

 

[portcity05]

Thanks Michael
Perfect, your help is very much appreciated, I was never going to get the answer you came up with.
regards Terry

 

[Michael M]

Glad to help...