Page 1 of 1

Excel question...

Posted: Thu Feb 23, 2006 3:54 pm
by Don Carlos
If i want to make a Cell say something if another was blank how would i do it?

for instance

If cell A1 was blank how would i make cell B1 say Please enter name in A1?

I assume its an IF formula?

Posted: Thu Feb 23, 2006 4:09 pm
by Don Carlos
=IF(A1>"","","Please Enter Name")

bleh had a mental block :)

Posted: Thu Feb 23, 2006 4:19 pm
by Ryoki
Man, i was actually very close to almost helping you. After some fiddling in Excel i came up with something rather similar.

Mine probably wouldn't have worked of course.

Posted: Thu Feb 23, 2006 4:29 pm
by MKJ
i can copy n paste in excell. does that help ?

Posted: Thu Feb 23, 2006 4:31 pm
by Ryoki
I can crop and resize images in Irfanview :icon14:

Posted: Thu Feb 23, 2006 4:35 pm
by MKJ
i thought those were your uber photoshop skills

Posted: Thu Feb 23, 2006 4:46 pm
by Ryoki
I've long forgotten those :tear:

Now, off to home with me.