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!!