| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SQL concatenation statement | Excel Discussion (Misc queries) | |||
| Can't add 7th IF statement to long formula. | Excel Worksheet Functions | |||
| SET statement tutorial | Excel Discussion (Misc queries) | |||
| If statement | Excel Discussion (Misc queries) | |||
| Do I need a sumif or sum of a vlookup formula? | Excel Worksheet Functions | |||
Linear Mode
