Need some help with an Excel equation

[mazeroth]

I have the following equation in Excel that I need some help with:

=(Dx/F1)G1

The Ds are variables in the equations while F1 and G1 are static for the whole spreadsheet. I have a column of numbers I enter for the D values and if the equation yields a result over 40 I have to report the result. What I?m wondering is if I can make a cell that will show what D needs to be in order for the equation to be 40. If I can do this I can cut down on a lot of my time. I usually just type in numbers in one of the D cells until the result gets very close to 40 but since this is used as a professional document I would like a cell that states something like ?All results less than xxx not reported due to having less than 40?.

Also, this just popped into my head. How do I make excel paste a number into a text statement? Is it something like ?All results less than (T1) not reported due to having less than 40.?

Thank you very much.

 

[mayest]

If I understand you question, you can just do a little algebra to solve for Dx:

40 = Dx/F1*G1

so, your formula would be:

= 40/G1*F1

For your text formula, use this in a cell:

="All results less than "&Text(xxx,"#")&" not reported due to having less than 40?

where xxx is a reference to a cell that contains the number xxx.

 

[KLin]

Are the values in the D column whole numbers, or can they be decimal values"

 

[mazeroth]

Originally posted by: KLin
Are the values in the D column whole numbers, or can they be decimal values"

First off, thanks mayest. I'll give that a shot.

They are whole numbers.