Anybody Good With Microsoft Excel? - HotUKDeals
We use cookie files to improve site functionality and personalisation. By continuing to use HUKD, you accept our cookie and privacy policy.
Get the HUKD app free at Google Play

Search Error

An error occurred when searching, please try again!

Login / Sign UpSubmit

Anybody Good With Microsoft Excel?

pugw$sh Avatar
6y, 11m agoPosted 6 years, 11 months ago
Anybody out there can help with an Excel spreadsheet? What I would like to do is create a formula which depending on a text entry adds or subtracts from the number in the cell above. For example in cell F7 the text is either "IN" or "OUT", if the text is "OUT" I want to add 1 to the number in cell G6, if the text is "IN" I want to subtract 1 from the number in cell G6, this formula would be for cell G7.

Does that make sense and can anybody help? I've been playing around with formula for an hour or so and I can't get anything to work.
pugw$sh Avatar
6y, 11m agoPosted 6 years, 11 months ago
Options

All Comments

(4) Jump to unreadPost a comment
Comments/page:
1 Like #1
Would that not be "=IF" ?
1 Like #2
You need to use some kind of nested IF statement as above e.g.
=IF(F7="IN",1,IF(F7="OUT",-1))
1 Like #3
an if always solves everything
=IF(F7="out", G6+1,G6-1)
that would work, even if F7 is gkkj then it still would do G6-1
or
=IF(F7="out",G6+1,IF(F7="in",G6-1,"error"))
if you want a function that will only do those calculation when G7 is either out or in, otherwise it would say error.

hold on did you want the number in G6 to be replaced by the new number? the IF statement above wont do that.
#4
Cheers got it sorted thanks for your help.

Rep for all.

Post a Comment

You don't need an account to leave a comment. Just enter your email address. We'll keep it private.

...OR log in with your social account

...OR comment using your social account

Thanks for your comment! Keep it up!
We just need to have a quick look and it will be live soon.
The community is happy to hear your opinion! Keep contributing!