Simple Logic

**JTBS666** · 12-13-2023, 04:48 AM

I'm a treasurer for two small associations and use excel for my accounts.

The problem I have this: I wish to look at a cell value, and if its value is positive to the value of 0.01 or greater, then the second cell must show half its actual value whilst the first cell continues to be 0.01 or greater.

I have tried various combinations but continue to fall foul of syntax etc.

Probably a simple solution but not too me at the moment.

Regards,

John S

**AliGW** · 12-13-2023, 04:50 AM

Welcome to the forum.

Not sure I follow you, but a cell can contain EITHER a value OR a formula, but not both. YOu might need VBA for this, however there are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

**JTBS666** · 12-13-2023, 04:56 AM

2nd attempt:
For example
Cell C28 contains a simple formula that displays a result.

Cell G28 also contains a simple formula that displays a result.

IF Cell C28 displays a value of 0.01 or greater, then the value of G28 must be halved.

**TMS** · 12-13-2023, 04:59 AM

Maybe

Formula:

Please Login or Register  to view this content.

**AliGW** · 12-13-2023, 04:59 AM

In that case it needs to be incorporated into the formula in G28.

What are the two formulae used?

Something like:

=your_formula/IF(C28>=0.01,2,1)

**JTBS666** · 12-13-2023, 05:01 AM

Thanks, I'll take a look later this evening.

**AliGW** · 12-13-2023, 05:02 AM

Let us know how you get on. If that's not it, then share your formulae and/or a sample aorkbook to give us a better chance of assistong you.

**TMS** · 12-13-2023, 05:02 AM

In G28:

Formula:

Please Login or Register  to view this content.

**TMS** · 12-13-2023, 05:03 AM

Ali's solution is neater and not repetitive

**JTBS666** · 12-15-2023, 08:35 AM

Thanks to Ali and TMS, both achieved the desired result - apologies for delay to your replies, a bad dose of man flu.

**TMS** · 12-15-2023, 09:08 AM

No problem. Hope you are feeling better.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

**AliGW** · 12-15-2023, 11:04 AM

You're welcome.

Please follow TMS' instructions on signing off this thread.

**AliGW** · 12-16-2023, 06:05 AM

Thanks for the rep - please mark the thread as solved as adised above.

**TMS** · 12-16-2023, 06:33 AM

Thanks for the rep and for marking the thread as solved

.

Simple Logic

LinkBack

Thread Tools

Rate This Thread

Display

Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Re: Simple Logic

Thread Information

Users Browsing this Thread

Similar Threads

Why is this Simple Excel Logic (IF/THEN) escaping me? Please help!!

[SOLVED] simple logic test

Unable to program a simple logic

Simple Logic question

[SOLVED] Simple Formula, cant get logic to work

Need help transferring this logic to simple excel formula

[SOLVED] Simple multiple logic test help

Bookmarks

Bookmarks

Posting Permissions