How to make a cell display a minimum value

  • Thread starter Thread starter julwalsh
  • Start date Start date
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?.
 
=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
 
Back
Top