Special criteria formula

[guyzk1]

Hi guys,

I need a formula for something like this (all the column leters a examples only)

1. Column A - a column with a Y/N choice
2. Column B - a column with a number (e.g. 10000)
3. Column C - column with a percentage in a positive or negative value (e.g. -40%) the column is formated by percentage.
4. Column D - the column using the formula

the formula I need is:

If "column A" = "Y" (Yes) then "column D" = "column B" minus/plus the value in "column C"
If not leave blank.

The correct answer should be (by the numbers I gave above)
If "column A" = "y", then Column D = 10000 -40% = 6000.

If "column C" was a positive value then the answer wil be:
"Column D" = 10000 + 40% = 14000

I hope someone could help me.

[sweep]

Hi,

=IF(A2="Y",B2+(B2*C2),"")

remember to format the cell where this formula goes as a general number

Format > Cells > Number > General

HTH

Dave

[starguy]

Hi guys,

I need a formula for something like this (all the column leters a examples only)

1. Column A - a column with a Y/N choice
2. Column B - a column with a number (e.g. 10000)
3. Column C - column with a percentage in a positive or negative value (e.g. -40%) the column is formated by percentage.
4. Column D - the column using the formula

the formula I need is:

If "column A" = "Y" (Yes) then "column D" = "column B" minus/plus the value in "column C"
If not leave blank.

The correct answer should be (by the numbers I gave above)
If "column A" = "y", then Column D = 10000 -40% = 6000.

If "column C" was a positive value then the answer wil be:
"Column D" = 10000 + 40% = 14000

I hope someone could help me.

try this

=IF(A1="Y",B1+(B1*C1),"")

[guyzk1]

Hi guys

Thanks for the answers WORKS PERFECTLY!

[starguy]

Hi guys

Thanks for the answers but I just get a 0 value

The problem is that I can't get this calculation right:

(B12) "10000" - (C12) "-40%" = (D12) "6000"

just to clarify column formating is as follows

B12 - Number format
C12 - Percentage (no decimals)
D12 - Number format

in my workbook it works fine.
you can also use this

=IF(A1="Y",B1*(1+C1),"")

if it not works you should attach a sample file.

[guyzk1]

Both formulas work perfect, I simly had a mistake in the column letters.

Thanks alot guys!

[starguy]

Both formulas work perfect, I simly had a mistake in the column letters.

Thanks alot guys!

you're welcome. good to see that your problem is solved.