• Status: Solved
• Priority: Medium
• Security: Public
• Views: 269

# IF function in excel with a condition

If A1 is between 1 and 243 then use 244 to multiple 5.00 but when it's over 244 use the actual value in A1 to multiple it by 5.00

Trying to do an if statement in excel to automate a spreadsheet
0
plam125
• 5
• 4
• 2
• +1
3 Solutions

Commented:
try this
``````if A1 >= 1 and A1 <=243
then 244 x 5.00
else A1 x 5.00
``````
0

Commented:
=IF(A1>244,A1*5,243*5)
0

Director of ITAuthor Commented:
but when it's zero it's still multipying...
0

Commented:
should it not be

=IF(A1>244,A1*5,244*5)
0

Commented:
or like this:

=IF(AND(A1>=1,A1<=243),244*5,A1*5)
0

Commented:
To avoid the 0 condition:

=IF(A1<>0,IF(AND(A1>=1,A1<=243),244*5,A1*5),"")

jppinto
0

Commented:
sorry that was my typo above i used <=243

but it should be <=244 as it is above 244

change above to

=IF(A1<>0,IF(AND(A1>=1,A1<=244),244*5,A1*5),"")
0

Commented:
om my

just ignore my last comment my head is wrecked lol ;-0)
0

Commented:

=IF(A1<>0,IF(AND(A1>=1,A1<=244),244*5,A1*5),"")

it should be:

=IF(A1<>0,IF(AND(A1>=1,A1<=243),244*5,A1*5),"")
0

Director of ITAuthor Commented:
Thanks...that worked
0

Commented:
aw i know jppinto

i think i need a break lol
0

EngineerCommented:
Although it is closed a minor simplification

=IF(A1<>0,IF(AND(A1>=1,A1<=243),244,A1)*5,"")
0

## Featured Post

• 5
• 4
• 2
• +1
Tackle projects and never again get stuck behind a technical roadblock.