Excel function question

-
Hello,

Which spreadsheet function in Excel will display 6 as the output in the following formula?

=(36)
See more 

3 replies

Best answer
Posts
13036
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
October 11, 2019
1460
1
Thank you
DUH!!!!

UH , that's the square root, so that would be: =SQRT(36)

DUH!!!!


This sounds like homework, but I hope EVERYONE LEARNED SOMETHING!

Say "Thank you" 1

A few words of thanks would be greatly appreciated. Add comment

CCM 6415 users have said thank you to us this month

Respond to ac3mark
Posts
2535
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 15, 2019
368
0
Thank you
Hi 1234ah,

When A1 = 36 and because of that you want to display 6 in another cell, then use this:
=IF(A1=36,6,"")

Best regards,
Trowa
Respond to TrowaD
Posts
2403
Registration date
Sunday September 23, 2012
Status
Moderator
Last seen
December 13, 2018
494
0
Thank you
Hi,

Do you want your formula to output the last digit of any number?
Respond to Zohaib R