Excel question...

Post by **Don Carlos** » Thu Feb 23, 2006 3:54 pm

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?

Post by **Don Carlos** » Thu Feb 23, 2006 4:09 pm

=IF(A1>"","","Please Enter Name")

bleh had a mental block

Post by **Ryoki** » Thu Feb 23, 2006 4:19 pm

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.

Post by **MKJ** » Thu Feb 23, 2006 4:29 pm

i can copy n paste in excell. does that help ?

Post by **Ryoki** » Thu Feb 23, 2006 4:31 pm

I can crop and resize images in Irfanview :icon14:

Post by **MKJ** » Thu Feb 23, 2006 4:35 pm

i thought those were your uber photoshop skills

Post by **Ryoki** » Thu Feb 23, 2006 4:46 pm

I've long forgotten those

Now, off to home with me.