I have this formula that works fine, but now I'd like to add a condition. Unfortunately my suggestion doesn't work. Basically, a value should only be shown as long as there is no value in either cell R or S, so I'm assuming the formula below should be connected to an OR statement at the end, as all the other conditions below should continue to apply if cell R or S are empty:
Please Login or Register to view this content.
I don't see any reference to cells R(??) or S(??) ??
Not sure exactly what it is you are looking for?
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Ah, but there is no reference to cell R or S (yet). That's the part I need help with
Okay...does this apply to the main(first) if statement where you have the "" ?
Try this
replace the "" with
IF(AND(R1="";S1="");'yourformula/data';"")
If both R1 and S1 are empty, then your formula applies, otherwise, if either has a value, nothing shows up?
Hope this helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks