Seting the minimum value in a cell

[[email protected]]

i am trying to get a currency cell to have a minimum value of =A30 (i
dont want it to go into -=A3)..the cell has a simple formula in it...so
i need to have the formula still....i tryed typing in MIN (0) but that
didnt work....im guessing its in some sort of properties....can any1
help

thanks

[JON JON]

Assume you input data in A1 and your formula in A2

Select A1
Goto Data>Validation
In settings tab Allow: Custom, Formula: =A2>0

You may want to look at other settings and customize to suits your need.


<[email protected]> wrote in message
news:[email protected]...
i am trying to get a currency cell to have a minimum value of £0 (i
dont want it to go into -£)..the cell has a simple formula in it...so
i need to have the formula still....i tryed typing in MIN (0) but that
didnt work....im guessing its in some sort of properties....can any1
help

thanks

[VBA Noob]

You could also try formatting the cell as

[>0]#,##0;;;

or a If statement

=if(A30<=0,"",A30)
VBA Noob

[[email protected]]

ok....the cell is i11.....and all it is doing is =3DH11-500........its
currency....basically ....if H11 is less than =A3500 then the cell i11
goes into minus.....instead of that i jst want it to say =A30.....any
ideas?

[MartinW]

Hi crispy,

Try this in I11

=IF(H11-500<0,0,H11-500)

HTH
Martin

[[email protected]]

hey.........thank u....life saver lol

[Carlos Antenna]

=MAX(H11-500,0)

--
Carlos

"MartinW" <[email protected]> wrote in message
news:%[email protected]...
> Hi crispy,
>
> Try this in I11
>
> =IF(H11-500<0,0,H11-500)
>
> HTH
> Martin
>