Cell Calculations

L

Lilbit

Please explain these formulas to me:
If(A1>1,000,000,000,500,000,A1-F3)
If(A1>500,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!!
 
B

Bob Phillips

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)
 
L

Lilbit

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?
 
B

Bob Phillips

Do you mean like

=IF(A1-F3>1000000000,500000,A1-F3)


--

HTH

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

Lilbit

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.
 
Top