sqrt(44²+45²)-1=61.93648 if>53then-53if decimal round up I need to write this in excel. for example I have A1=44 A2=45 all results must be less or iqual to 53 and round the decimals. how to do this in one cell, I don't want to separate results.

Hi So if the answer >53 you want to to subtract 53 and round up to what ie integer or some decimal position, and if it,s that answer >53 what want to display 53.

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History