I'm struggling with a formula - need help :-)

sammya · Oct 7, 2005

Hi There

I'm Sam from Paignton in England.

I've just signed up to this forum and I would like to see how helpful people are and what kind of advice you can give me.

I'm a bit of a beginner at excel formulas and am wondering if someone would help me.

here goes:

I need to Input a number into cell C4 and then I would like the following cell to do:

D4 subtracts 10% of C4 unless A4 contains the characters MA then I need it to subtract 15%

Please respond because I'm really struggling with this :4-dontkno

Thanks!

mgoldb2 · Oct 7, 2005

The following formula will do it

PHP:

=IF(A4="MA",C4-(C4*0.15),C4-(C4*0.1))

Explanation

The conditions for IF is IF(logical test, what to do if true, what to do if false)

Logical test tests a condition. Usually logical test if formated ((cell label) (logical test symbol) (value or cell label)

Logical tests symbols are things like >(greater then) <(less then) =(equal) etc.

Values are either a number or a string with " " around it.

condition 2 and 3 is self explantory. if the logical test comes out to true it does condition 2 otherwise it does condition 3.

sammya · Oct 7, 2005

Thanks very much!

No doubt I will be back soon with more troubled formulas!

I'm struggling with a formula - need help :-)

Top Contributors this Month

Recommended Communities