Hi,
I am using Excel 2003. So far I have this formula in a cell... =IF(B2=0,"",150/H2) , and it works perfectly. What I want to do is add to the fomula saying... If 150/H2 exceeds $73,000/E2 cap the value returned to 73,000/E2.
To make it as clear as I can... Ex: 150/H2 is $150/.05 equaling 3000, I want it to be capped at 73,000/E2... Ex: 73,000/$30 returning a value of 2433.
I'm really new with Excel. Thanks.
Last edited by Max9; 03-25-2011 at 03:20 AM.
Hi and Welcome!
Try modifying your formula like this:
Cheers,
Please Login or Register to view this content.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
It works perfect... Thank you very much ConneXionLost.Originally Posted by ConneXionLost
Hi and Welcome!
Try modifying your formula like this:
Cheers,Please Login or Register to view this content.
Max
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks