CODEWITHSUNDEEP
databaseexcelif-statementexcel-formula
kevincua
kevincua

Reputation: 17

How to do an if statement in excel

I'm trying to do an if and statement in excel for a query like this 

 If $age = <65 and $income = <90,000 then - 27.82% from $premium

So far I've got 

 =IF(AND(E4<65,F4 <90000), 800-27.82%)

but it just gives me

799.7218 as an answer when It should be giving me 577.44

Upvotes: 0

Views: 68

Answers (3)

jsw85
jsw85

Reputation: 11

Your "then" clause, the 800-27.82%,, is being interpreted as 800-0.2782, which is 799.7218.

If you want to reduce the value by 27.82%, you need to multiply it, like 800*(1-0.2782)

Upvotes: 1

Robby Cornelissen
Robby Cornelissen

Reputation: 97152

This should work:

=IF(AND(E4 < 65, F4 < 90000), 800 * (1 - 0.2782))

Upvotes: 0

Dai
Dai

Reputation: 155270

Try

=IF( AND( E4 < 65, F4 < 90000 ), 800 - (0.2782 * A1 ) )

...where A1 is your $premium value.

Upvotes: 0

Related Questions