• 669K Members
• 9,974 Online
• 825K Conversations

## simple "if" formula that i cant work out.

Highlighted
Occasional Visitor

# simple "if" formula that i cant work out.

Hi,

Can some please write the "if" formula for below.

Thanks.

If F22 is equal to or greater than 9000 but less than 15000 then put 5% of the value of F22 into E25. If F22 is equal to or greater than 15000 then put 6% of the value of F22 into E25.

5 Replies
Highlighted

# Re: simple "if" formula that i cant work out.

Hi,

That could be

`=F22*IF(F22>=15000,0.06, IF(F22>9000,0.05,0))`
Highlighted

# Re: simple "if" formula that i cant work out.

Hello, I tested it and here’s my screenshot for you. If you enter a number in a2 you can the result in d2. Additionally you can refer to another cell in f22 with „=d2“ . Greets, Eva
Highlighted

# Re: simple "if" formula that i cant work out.

Hello, I tested it and here’s my screenshot for you. If you enter a number in a2 you can see the result in d2. Additionally you can refer to another cell like f22 with „=d2“ . Greets, Eva
Highlighted

# Re: simple "if" formula that i cant work out.

try this:-

=IF(AND(F22>=9000,F22<15000),E25+F22*5/100,IF(F22>=15000,E25+F22*6/100,"N/A"))

if not get ur solution, than share some sample data

Regards

Naveen

Highlighted

# Re: simple "if" formula that i cant work out.

try this:-

=IF(AND(F22>=9000,F22<15000),E25+F22*5/100,IF(F22>=15000,E25+F22*6/100,"N/A"))

if not get ur solution, than share some sample data

Regards

Naveen