How to make a cell display a minimum value

J

julwalsh

Hi

I have a very simple spreadsheet that works the total area of a piece
of glass. Similar to this

Width Height Area

Where Area = Width*Height

I want to make it so that the Area cell will display a minimum value if
a certain value is too low. For instance .478*.456 is actually equal
to 0.217, but I want to make the minimum area 0.30. this makes it that
any value that is returned in the Area cell must be a minimum of 0.30.
Anything over 0.30 is OK. I would assume that a command similar to
this would suffice

If C3 < 0.30 then Let C3 =.30

But, where do I type this?

Can anyone help?.
 
M

MOSHE

=IF(A5*B5<0.3,0.3,A5*B5)

use the "IF" function
Assuming that you have the first value in cell A5 and the second value
in B5 , then you could put an IF in C5 , or any cell that you feel like
(exept A5 or B5).
The if function ,as you assume has a form of if a statement is true
then do A if not do B.
The proper format is =if(statement,action if true,action if false)
You have to insert commas between each statement

In the function above, if (a5*b5 ) is smaller than .03 then , return
to cell C5 (or whichever cell you write the formula in) the value .03
if the product is larger than .03 then return the product

Good luck

Moshe
 
Top