Calculate Mod of number on cell with condition

Hi guys,

I need help on formular

I have a finger table on DHT (Broadcasting Network), on the cell C6 i have number 522 and i want to display the result on D6 . Condition of this formular is " If the number on cell C6 is over OR equal 513, that number will be moded with 512".


Thanks guy

Sr guy, let me paraphase it,


if a+b =513 or over, then the formula (a+b mod 512) will b used -> The number is on Cell C6 . Fomular has to be typed on D6 , this is where the result is displayed

henry220,

If I understand your request, the following formula should work for you:

=IF(C6>=513,512,C6)

If C6 is 512 or less, D6 will display the number located in C6. If C6 is 513 or higher, D6 will display 512.

Thanks,
Cirenav

Thanks it work, thanks again guys

Sr last question :D.

How can you do this function within 1 cell: if A1 >=0, then display 0, else if A1 >=5, then display 5, else if A1>=10, then display 10. I dont really know how to combine all the function into 1 cell only