Microsoft Excel how to

  • Thread starter Thread starter Trish
  • Start date Start date
T

Trish

In Microsoft Excel how to...

A1 B1 C1
250 5.67 =B1*0.75%

The value in C1 is (normaly 0.75% of A1) 0.04 as per the above formula. But
the A1xC1>=20 should be minimum. So the answer in C1 should be 0.08 (20/A1)
(20/250).

At present I am correcting the entry in C1 manually, but somebody please
help me to create a formula to do it automatically.

Thanks for all the replies and help.

Trish
 
Trish said:
In Microsoft Excel how to...

A1 B1 C1
250 5.67 =B1*0.75%

The value in C1 is (normaly 0.75% of A1) 0.04 as per the above
formula. But the A1xC1>=20 should be minimum. So the answer in C1
should be 0.08 (20/A1) (20/250).

At present I am correcting the entry in C1 manually, but somebody
please help me to create a formula to do it automatically.

Thanks for all the replies and help.
Click to expand...

This is the Windows XP General newsgroup.
Excel is not a part of Windows XP.
This is a very specific question.
Try in an Excel newsgroup.

http://www.microsoft.com/office/com...?dg=microsoft.public.excel.misc&lang=en&cr=US
or
http://www.microsoft.com/office/com...ublic.excel.worksheet.functions&lang=en&cr=US
or
http://www.microsoft.com/office/com...microsoft.public.excel.newusers&lang=en&cr=US

Maybe...?
 
firstly, you should post this
in the microsoft.public.office.misc

secondly, you simply need
more practice with excel.

thirdly, (as a hint) don't simply
use 3 columns. Instead take adavantage
of the other columns for the additional
formulations, like those described in your
posting below.

PS: C1 could be =sum(b1*0.75)

There are helpful books on Excel
 
Hi Trish. To be clear about what you are asking - You want a formula in C1 that
will return EITHER B1*0.75% OR 20/A1 if B1*0.75% is less than 20. Is that
correct?
If not please clarify.

Gerry
 
Trish said:
In Microsoft Excel how to...

A1 B1 C1
250 5.67 =B1*0.75%

The value in C1 is (normaly 0.75% of A1) 0.04 as per the above formula.
But the A1xC1>=20 should be minimum. So the answer in C1 should be 0.08
(20/A1) (20/250).

At present I am correcting the entry in C1 manually, but somebody please
help me to create a formula to do it automatically.

Thanks for all the replies and help.

Trish
Click to expand...

What are you smoking? And is there any possibility you can share it with the
rest of us? Sounds like good shit!

Cheers.


--
Linux is ready for the desktop! More ready than Windoze XP.
http://tinyurl.com/ldm9d

"Computer users around the globe recognize that the most serious threats to
security exist because of inherent weaknesses in the Microsoft operating
system." McAfee
 
In Microsoft Excel how to...

A1 B1 C1
250 5.67 =B1*0.75%

The value in C1 is (normaly 0.75% of A1) 0.04 as per the above formula. But
the A1xC1>=20 should be minimum. So the answer in C1 should be 0.08 (20/A1)
(20/250).

At present I am correcting the entry in C1 manually, but somebody please
help me to create a formula to do it automatically.

Thanks for all the replies and help.

Trish
Click to expand...

I should not respond due to off-topic, but since I know
spreadsheets... Your statement
But
the A1xC1>=20 should be minimum. So the answer in C1 should be 0.08 (20/A1)
(20/250).
Click to expand...

makes no sense. I'm thinking you need to use an "IF" statement to
compare two cells then enter one of two formulas into a cell. The
help in Excel is usually quite helpful. Gosh, I miss Lotus 1-2-3.
 
Trish said:
Yes, you are right. Thanks for the reply Gerry Atrick.
Click to expand...
In that case, Trish, the formula to put in C1 is
=IF(B1*0.75%<20,20/A1,B1*0.75%)

Hope this helps.

Gerry
 
Back
Top