Seting the minimum value in a cell
 

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

Seting the minimum value in a cell
 

Assume you input data in A1 and your formula in A2

Select A1
Goto DataValidation
In settings tab Allow: Custom, Formula: =A20

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


wrote in message
ups.com...
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

Seting the minimum value in a cell
 

You could also try formatting the cell as

[0]#,##0;;;

or a If statement

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


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=559589

Seting the minimum value in a cell
 

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?

Seting the minimum value in a cell
 

Hi crispy,

Try this in I11

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

HTH
Martin

Seting the minimum value in a cell
 

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

Seting the minimum value in a cell
 

=MAX(H11-500,0)

--
Carlos

"MartinW" wrote in message
...
Hi crispy,

Try this in I11

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

HTH
Martin