LTurner3692 Posted February 5, 2019 Posted February 5, 2019 Hello All, Im trying to get a formula to do as i want but being stupid i cant work it out! The formula is =IF((AND(A15>=60,A15<=60)),0,(A15-60*C15)) So what im after is if A15 is 60 or below then nothing happens but if its above 60 i want to take 60 off and multiply! Where am i going wrong?
Mako Posted February 5, 2019 Posted February 5, 2019 If I'm understanding your request properly: =IF(A1<=60,"-",(A1-60)*A2) If A1 is less than or equal to 60, then nothing. Unfortunately you can't have a "do nothing", so I've replaced the value with a dash. Otherwise you take A1 and subtract 60, then multiply the result by whatever cell you want. 1
LTurner3692 Posted February 5, 2019 Author Posted February 5, 2019 Thats the ticket! i knew it was easier than i was making it out to be!
SeanAllen Posted February 7, 2019 Posted February 7, 2019 You can use empty quotes "" that'll leave the cell empty.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now