i am looking to create a simple formula ,
i say simple even though i can do it . :rofl: :rofl:
but here we go
if column Fab pack issued is not blank ( or fab pack issued in full is selected ) i want area value indicated in formula column
if i place a order for example 500 and then it is part shipped in 5 deliveries resulting in 5 invoices . can i have all involves values in one cell ( 100+100+100+100 ) this is then sum into new cell giving me a value of 400. i dont want to be creati...
i need to round up the following formula
what i require is any value between 0 to 0.49 to be 0.5 and any value to be between 0.5 and 1 to be 1
and so on up .
so were constantly rounding up by the nearest 0.5
IF( YFF ,ROUNDUP( YFF ,0)-IF( YFF -ROUNDDOWN( YFF ,0)>0.5,0,0.5),0)
thanks for your help and perhaps you can have a look at this again , for me
below is what your formula gives me and i have inserted a manual column of what i hope t...