IF AND formula

[maywal]

I am sure I am making a very simple mistake but can't seem to find the solution.

I am using this formula:

=IFERROR(IF($F3="GTS",$M3,(IF(AND(H3="Manual",F3="GTS"),I3,""))),"")

I need to differentiate between manual entry and formulated inputs.

Column H has the option to select 'manual' for manual entries of data, and I then want to copy the manual entry into the new box if it also equals 'GTS' in column F.

On other occasions formulas will feed off of M3 were fees have been standardised and therefore I need it to differentiate the two.

Assuming this is the right formula, am I writing this in the wrong order?

Any help would be much appreciated in understanding how this works.

 

[snjpverma]

try this
=IF(AND(H3="Manual",F3="GTS"),I3,M3)

 

[Marcílio_Lobão]

maywal, Good afternoon.

Try to use:

[B]=IF($F3="GTS", IF(H3="Manual", I3, M3), "")[/B]

Is that what you want?

I hope it helps.

 

[maywal]

=IF(AND(H3="Manual",F3="GTS"),I3,IF(F3="GTS",M3,""))

The one above works, just tweaked yours a little. I was making it too complicated clearly.

Thank you!

 

[Marcílio_Lobão]

maywal,

Glad to have helped you.

Thanks for the feedback.