Cell Calculations
 

Please explain these formulas to me:
If(A11,000,000,000,500,000,A1-F3)
If(A1500,000,500,000,A1)

Also, when I use the above formulas, A1 is produced by subtracting two
numbers. Is there a way to incorporate all of this in one formula?
Thanks!!

Personally, I cannot see how they work at all. It seems that the first is
saying

If value in A1 is greater than 1 billion then return 500 thousand, otherwise
return A1 minus F3. But all the commas in the 1 billion and 500 thousand
will throw a formula error.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lilbit" wrote in message
lkaboutsoftware.com...
Please explain these formulas to me:
If(A11,000,000,000,500,000,A1-F3)
If(A1500,000,500,000,A1)

Also, when I use the above formulas, A1 is produced by subtracting two
numbers. Is there a way to incorporate all of this in one formula?
Thanks!!

Thanks RP. I'm so use to typing numbers with commas, I neglected to
eliminate them when typing the formula in my question. Your response was
very helpful. That explains that; however, is there a way to incorporate
in that formula the value for A1 whose result is found by subtracting two
numbers?

Do you mean like

=IF(A1-F31000000000,500000,A1-F3)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Lilbit" wrote in message
lkaboutsoftware.com...
Thanks RP. I'm so use to typing numbers with commas, I neglected to
eliminate them when typing the formula in my question. Your response was
very helpful. That explains that; however, is there a way to incorporate
in that formula the value for A1 whose result is found by subtracting two
numbers?

Thanks again RP! I'm sure to you, that was way too easy, but to me, there
were too many possibilities to express that formula.