If(and formula help please

J

JC

IF AND FORMULA HELP FOR the following scenarios


I have four columns with data
example
row# AD AE AG AH AI
1 12 22 133.00 140.00 data in all columns so AE row2
should be =" "
" " "" " " " "
12 122.00 0 no data in AE so row2 should be
" " 1 " " " "
15 0 144.00 no data in AE
1 " " "" " "
blank blank blank blank no data in all row
" " " " " " " "
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if(and(isblank( formula help 2
blank cell instead of x 2
How do I make a cell blank if Error OR 0 Result 2
Counting number of cells until a criteria is met 0
Formula for Range area within VLookup? 3
Concatenation frustrations.... 8
if formula 1
Incrementing cell reference in Lookup formula 3

Top