IF/OR Statement needed

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

/Hi to all

I have a MAX statement that I think I need to add an If/Or statement in
front of to return a blank if the cell shows either a blank, a minus amt, or
a 0. Can someone please tell me how to write this part?

Thanks much
 
Hi Mike

Thanks for the input. The first part of your
formula-=IF(MAX(A1:A5)<=0,"",-worked for me. When I tried to use the whole
piece, then my part of the formula wouldn't calculate correctly. Also, I
managed to put together an IF/OR statement for the beginning that worked
also.

Thanks again!
 

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 OR Statements 4
If blank statement 4
Row Calculation 1
"If" statement returning blank gives downstream formula errors. 2
Multiple if statements 5
IF Statement Help 3
Three possible outputs from an if statement. 3
Help Please with If statement / vlookup 9

Back
Top