Can anyone tell me the formula for this? If the value of A1 is less than 1000 then add 10
Can anyone tell me the formula for this? If the value of A1 is less than 1000 then add 10
maybe this...
=IF(A1<1000,A1+10,A1)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Sorry I should have said that I'm having trouble incorporating a formula to add 10 if my cell if the value is less 1000, A1 contains this formula =SUM(H4:H114). I'm putting () in the wrong place I think.
=if(SUM(H4:H114)<1000,SUM(H4:H114)+10,SUM(H4:H114)
or...
=max(SUM(H4:H114)+10,SUM(H4:H114))
I didn't see your instructions below, thank you Ford, SOLVED!
Glad we got it resolved, and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks