Status
Not open for further replies.
1 - 3 of 3 Posts

sammya

·
Registered
Joined
·
4 Posts
Discussion Starter
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

·
Registered
Joined
·
604 Posts
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

·
Registered
Joined
·
4 Posts
Discussion Starter
Thanks very much!

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

1 - 3 of 3 Posts
Status
Not open for further replies.