formula problem- minimum cell values

  • Thread starter Thread starter Mick Worswick
  • Start date Start date
M

Mick Worswick

Hi all, Is it possible to do this.
I need a formula that will give a minimum value in a cell thats linke
to a cell on a different page yet still allow a true value if it i
over the minimum. Any help will be great, thanks in advance
 
Maybe you can rephrase that a bit, I simply don't understand what you mean?
Give us an example

--
No private emails please, for everyone's
benefit keep the discussion in the newsgroup.


Regards,

Peo Sjoblom
 
Sorry for the crap way I explained my problem,
I wanted a cell (A1) to show a value from (B10) returning a true numbe
as long as it was above 1.5 if the number was below 1.5 I needed it t
show 1.5.
I thought I may be able to do this with conditional formating but it'
not allowed, I managed to sort my problem using a hidden cell (A10
linked to(B10)

In (A1) I now have =IF(B10<1.5,1.5,A10) works fine

Thanks anyway
mic
 
Back
Top