Sorry to double post, but I need help in a hurry. Gotta leave for Milwaukee in a couple of hours....
How can I say "If cell value is > 1700 but < 2599, then * .25 else 0"? I'm actually working with the Microsoft Works spreadsheet, but I think the formulas are pretty much the same. It's been so long since I messed with this stuff.... Thanks much
Suppose the data is in cell A1 then the formula will be
=if( and( a1 > 1700 , a1 < 2599) , a1 * 0.25 , 0)
Shijesh Kumar
http://shijesh.wordpress.com/
=IF(AND(A5>1700,A5<2000),0.25,0)
regards
good luck
Originally Posted by amx1165
Whoop! Whoop!
Thank y'all!
amx1165
Please take a couple of minutes and read the Forum Rules - Rule 5
Your other duplicate thread has been closed
I have left this thread open as it has the most replies & also moved it to the Excel Worksheet Functions forum
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedI welcome your Feedback.
Sorry - and thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks