from arithmetic to excel

January 6, 2012 at 09:13:07
Specs: Windows XP
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.

See More: from arithmetic to excel

January 12, 2012 at 11:52:37

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.

Report •
Related Solutions

Ask Question