Thread: How to make a X amount equal $300,000
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
  
Posts: 3,355
Default How to make a X amount equal $300,000
Let's say you have the following:

A1: 480,000
B1: =A1 - 300,000

HTH,
Barb Reinhardt

"Valiant" wrote:

I am lost on finding out how to do this formula 480,000-?=300,000
How do i turn that question mark into a formula so that my answer is always
300,000. I want to make that ? equal to 180,000 in the other box.
Any body know how to do that?????
--
Cheers!!!
Reply With QuoteReply With Quote