Conditional Formatting Formula IF or SUMIF

**Lawman1** · 01-05-2017, 10:37 AM

Hello, I am having an issue trying to do a simple formula under Conditional Formatting. I am trying either the IF or SUMIF formula and neither are working. Here is what I am trying to do. i have cell AH104 labeled Round Trip and cell AM104 labeled Total Miles. When the Round trip cells have a "Yes" in them, I need the miles in the Round Trip cells to be doubled. I tried this: =IF($AH$105="Yes",SUM($AM$105*2),"") but to no avail. I tried a SUMIF function also, but it also didn't work. I know this is a simple fix, but it has me stumped for some reason. Thank you in advance for any and all help!

**mahju** · 01-05-2017, 10:55 AM

Hello and welcome to the form

I suggest you add another column Labeled "Total mile" in say in AN104
Then you can use this formula

In AN5

Please Login or Register  to view this content.

You can copy down it if needed

If it is not what you want, upload a sample file
Thanks

**Richard Buttrey** · 01-05-2017, 10:55 AM

Hi,

You can't use Conditional Formatting to CHANGE a value. Cond Formatting - as its name suggests is only for formatting i.e. changing colours, fonts etc.

Without a macro you'll need to use an additional cell
e.g.
=AM105*IF(AH104="YES",2,1)

**mahju** · 01-05-2017, 10:56 AM

Hello and welcome to the form

I suggest you add another column Labeled "Total mile" in say in AN104
Then you can use this formula

In AN5

Please Login or Register  to view this content.

You can copy down it if needed

If it is not what you want, upload a sample file
Thanks

**Lawman1** · 01-05-2017, 02:20 PM

Thanks for the help! It works just as you have suggested!

**mahju** · 01-06-2017, 10:14 AM

If you are satisfied with the answers, please mark the thread as solved.
In you first post under thread tools

Thanks

Conditional Formatting Formula IF or SUMIF

LinkBack

Thread Tools

Rate This Thread

Display

Conditional Formatting Formula IF or SUMIF

Re: Conditional Formatting Formula IF or SUMIF

Re: Conditional Formatting Formula IF or SUMIF

Re: Conditional Formatting Formula IF or SUMIF

Re: Conditional Formatting Formula IF or SUMIF

Re: Conditional Formatting Formula IF or SUMIF

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Expert Needed: Conditional Formatting and SumIF/VlookUp issue (Last row)

Formatting Cells with Date or Text Values in a Conditional Formatting Formula

[SOLVED] Conditional Formatting Formula - if(and(sumif.....

[SOLVED] sumif with conditional formatting

[SOLVED] Countif or Sumif based on Conditional Formatting Color

[SOLVED] copy the conditional sum (SUMIF) formula

copy the conditional sum (SUMIF) formula

Bookmarks

Bookmarks

Posting Permissions