Hi guys, I've been at this for well over an hour and google'd my butt off so I'm throwing myself at your mercy. I have a perfectly decent forumla - =IF(MOD($A4,B$2)=0,$A4/B$2,"---") - that as you can probably tell returns "---" when I get an undesirable result; my question is how in god's name do I add an additional condition so it outputs "---" when the result is >30 as well as 0? I've searched every tutorial and it makes sense but I cant seem to apply it to this?
I may just be having one of those mornings
Any help will be smothered with love and furry things
Bookmarks