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

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

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

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?

Hi crispy,

Try this in I11

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

HTH
Martin

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

=MAX(H11-500,0)

--
Carlos

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

Try this in I11

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

HTH
Martin