Need some help with an IF OR Forumla for my spreadsheet

[Abell88]

I have a somewhat different billing system.

1st User= 4 files minimum
additional Users= 3 file minimum

ex: 2 user= 7 files minimum (4 +3)
3users= 10 files
4users= 13 files

A1 is # of users and A2 column is minimum # of files needed (based on # of users)

I am not sure how to write the formula

= ((A1=1,*4) OR (IF A1><1, (A1-1*3+4))

Please help. Thank you!

 

[Greymud]

It's less complicated than you think.

(A1-1)*3+4
Solve for A1=1

(1-1)*3+4
(0)*3+4
0+4
4

 

[SQUIDD]

abel

is this now resolved or are you needing further assistance?

Dave