Seting the minimum value in a cell

[crispydcrisp]

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

 

[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.


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 Noo

 

[crispydcrisp]

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

 

[MartinW]

Hi crispy,

Try this in I11

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

HTH
Martin

 

[crispydcrisp]

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

 

[Carlos Antenna]

=MAX(H11-500,0)