Basic question for a beginner

  • Thread starter Thread starter reo4966
  • Start date Start date
R

reo4966

Hello! My question is I need help putting the following into a formula
if it is possible.
1.) I have a total #
2.) I divide that total # by 12
3.) The total I receive from that division (here's my problem)
If the answer is less than 16, then the answer is 16
If the answer is greater than 16 then the answer needs to hav
10% added to it.

I only know basic, very basic excel. So if someone could help me tha
would be great!

Thanks,
René
 
Hi reo4966!

Use:
=IF(A1/B1<16,(A1/B1)*1.1,A1/B1)

The first argument is the condition. IF function conditions MUST
resolve to TRUE or FALSE and can be tested on their own using:

=A1/B1<16

The second argument is what is to be returned if the condition is TRUE
and the third argument is optional and returns if the condition is
FALSE.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Renee,

I would use the following formula based on that the
calculation is in c1

=If(c1<16,16,c1*1.1)
 
Thank you very much for your help!
I do however, have one more question. Is it possible to put in bot
formulas into one? I mean the >16 and <16?
I wanted to use one cell but two is fine.

Thanks again!
Renée:
 
I think the OP wanted the answer to be a minimum of 16. This would work:


=IF(A1/B1>16, A1/B1*1.1, 16)

OTOH, I'm not sure whether the comparison should be > or >=, since the
OP didn't say what should happen if the result is exactly 16.

This might work, too:

=MAX(16/1.1, A1/B1) * 1.1
 
Let's say that your total is in A1.
The number to divide it by is in A2.
Try this formula in A3:

=IF(A1/A2<16,16,A1/A2*1.1)
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================




Thank you very much for your help!
I do however, have one more question. Is it possible to put in both
formulas into one? I mean the >16 and <16?
I wanted to use one cell but two is fine.

Thanks again!
Renée:)
 
HI JE!

(After breaking to get 3rd cup of coffee), Thanks!

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Renee,

They are already both in one. The formula says

If C1 < 16, return 16, otherwise (if C1 >= 16) return C1*110%

If you want some special action for C1 =116, then use

=IF(C1<16,16,IF(C1>16,C1*110%,C1*90%))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Renee,

The formula provided does include >16 and <16 in one
formula. Are you asking for a formula that will divide
and calculate the difference in the same cell?

Ben
 
Back
Top