IF Statement
 

I have a work sheet, 4 columns., d, e, f, g

I need to write an IF statement that fixes the following problem

Column D will always have a value in it.
IF column E has a value in it, but F, and G, do not, then value in column D*30
IF column F has a value in it, but E and G, do not, then value in column D*30
IF column G has a value in it, but E and F do not, then value in column D*30
IF column E and F has a value in it, but G does not, then value in column D*37
IF column E and G has a value in it, but F does not, then value in column D*37
IF column F and G has a value in it, but E does not, then value in column D*37

Is there anyway to write this formula? My problem is that the values in any
of these columns could be any positive number, or they could be blank. Any
suggestions would be great.

Sincerely,
Chris Lamutt

IF Statement
 

try
=MAX(E2:G2)*D2*(30+IF(COUNT(E2:G2)1,7,0))

--
Don Guillett
SalesAid Software

"Chris Lamutt" <Chris wrote in message
...
I have a work sheet, 4 columns., d, e, f, g

I need to write an IF statement that fixes the following problem

Column D will always have a value in it.
IF column E has a value in it, but F, and G, do not, then value in column
D*30
IF column F has a value in it, but E and G, do not, then value in column
D*30
IF column G has a value in it, but E and F do not, then value in column
D*30
IF column E and F has a value in it, but G does not, then value in column
D*37
IF column E and G has a value in it, but F does not, then value in column
D*37
IF column F and G has a value in it, but E does not, then value in column
D*37

Is there anyway to write this formula? My problem is that the values in
any
of these columns could be any positive number, or they could be blank.
Any
suggestions would be great.

Sincerely,
Chris Lamutt

IF Statement
 

=CHOOSE( COUNT( E1:G1 ) + 1, "EMPTY", D1 * 30, D1 * 37, "FULL" )
--
Regards,
Luc.

"Festina Lente"


"Chris Lamutt" wrote:

I have a work sheet, 4 columns., d, e, f, g

I need to write an IF statement that fixes the following problem

Column D will always have a value in it.
IF column E has a value in it, but F, and G, do not, then value in column D*30
IF column F has a value in it, but E and G, do not, then value in column D*30
IF column G has a value in it, but E and F do not, then value in column D*30
IF column E and F has a value in it, but G does not, then value in column D*37
IF column E and G has a value in it, but F does not, then value in column D*37
IF column F and G has a value in it, but E does not, then value in column D*37

Is there anyway to write this formula? My problem is that the values in any
of these columns could be any positive number, or they could be blank. Any
suggestions would be great.

Sincerely,
Chris Lamutt

IF Statement
 

I misread to think that you wanted to multiply the largest value in the
columns. Use this.
=D2*(30+IF(COUNT(E2:G2)1,7,0))

--
Don Guillett
SalesAid Software

"Don Guillett" wrote in message
...
try
=MAX(E2:G2)*D2*(30+IF(COUNT(E2:G2)1,7,0))

--
Don Guillett
SalesAid Software

"Chris Lamutt" <Chris wrote in message
...
I have a work sheet, 4 columns., d, e, f, g

I need to write an IF statement that fixes the following problem

Column D will always have a value in it.
IF column E has a value in it, but F, and G, do not, then value in column
D*30
IF column F has a value in it, but E and G, do not, then value in column
D*30
IF column G has a value in it, but E and F do not, then value in column
D*30
IF column E and F has a value in it, but G does not, then value in column
D*37
IF column E and G has a value in it, but F does not, then value in column
D*37
IF column F and G has a value in it, but E does not, then value in column
D*37

Is there anyway to write this formula? My problem is that the values in
any
of these columns could be any positive number, or they could be blank.
Any
suggestions would be great.

Sincerely,
Chris Lamutt