Hi everyone,
I currently have a formula which is added the results of 8 vlookups together. What I would like is to add an if statement in the cell which states that if the result is greater than 1000 then the result will show as 1000, otherwise the result should be what the additional formula comes out to. I tried if(Y4>1000,1000,y4) but I got an error. Any thoughts?
Thanks!
so you're not adding that part to the 8 vlookups formula right (it is a stand alone formula)?
if so, maybe you need to add quotes around the "1000" since it is the output of other formulas. Have you tried that?
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Use
=MIN(your_formula,1000)
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks