Tech Support banner

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

·
Registered
Joined
·
4 Posts
Discussion Starter #1
Hi There :rolleyes: 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!
 

·
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.
 
1 - 3 of 3 Posts
Status
Not open for further replies.
Top