Take away formula

[leighmills33]

Hi guys what formula could I use to get a value from another cell then minus the value for say 36
so for example if a cell has 700 i would then like to display in another cell (700 -36) 664

[sweep]

Hi,

If 700 is in cell A1, your formula would be =A1-36

Type that in the cell where you want the result

[leighmills33]

Is there a way to only show the result if another cell equals 1

Thanks

[sweep]

yep. If you're looking for 1 in B1, i would become

=IF(B1=1,A1-36,"")