if 2<a2<3 return 10
if 4<a2<5 return 10*a2
else return 0
if 2<a2<3 return 10
if 4<a2<5 return 10*a2
else return 0
Last edited by AliGW; 07-10-2021 at 08:37 AM.
Your title is poor - I'll deal with that in a moment.
Try this:
=IF(AND(A2>2,A2<3),10,IF(AND(A2>4,A2<5),10*A2,0))
PLEASE find out what your Office version is and update your profile.
Last edited by AliGW; 07-11-2021 at 07:37 AM. Reason: Missing AND added
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
AliGW Jour formula errorFormula:Please Login or Register to view this content.
Well spotted! I've corrected it, thanks. I shouldn't worry, though - the OP has never been back.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks