**Question description:**

*This user has given permission to use the problem statement for this blog.*

I want to create a daily bonus tracker. "A" being target, "B" being actual. IF "B">"A" then cell = "B" how do i formulae this?

Solved by T. H. in 13 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
23/11/2017 - 10:16

Welcome, Thanks for choosing Got It Pro-Excel!

Excelchat Expert
23/11/2017 - 10:16

How may I help you today!

Excelchat Expert
23/11/2017 - 10:17

How may I help you today,please?

User
23/11/2017 - 10:17

i need a formula for the above please!

User
23/11/2017 - 10:17

I want to create a daily bonus tracker. "A" being target, "B" being actual. IF "B">"A" then cell = "B" how do i formulae this?

Excelchat Expert
23/11/2017 - 10:17

OK, Can you write here an example in right side sheet?

Excelchat Expert
23/11/2017 - 10:18

OK

Excelchat Expert
23/11/2017 - 10:18

I'll repeat please verify

User
23/11/2017 - 10:18

so bonus = actual if greater than target

Excelchat Expert
23/11/2017 - 10:19

Then in cell C2 it should 1?

Excelchat Expert
23/11/2017 - 10:19

Why 0?

User
23/11/2017 - 10:20

no C3 is 0 as C2 is not greater than C1

Excelchat Expert
23/11/2017 - 10:20

As you saidso bonus = actual if greater than target

Excelchat Expert
23/11/2017 - 10:20

C1?

User
23/11/2017 - 10:20

sorry i mistyped!

Excelchat Expert
23/11/2017 - 10:21

No worry

User
23/11/2017 - 10:21

C3 is 0 as B3 is not greater than A3

Excelchat Expert
23/11/2017 - 10:21

Then why C2 =2?

Excelchat Expert
23/11/2017 - 10:21

It should be 1?

User
23/11/2017 - 10:22

C2 is as B2 is equal or greater than A2

Excelchat Expert
23/11/2017 - 10:22

You need different formulas in C2 & C3?

User
23/11/2017 - 10:22

yeah

Excelchat Expert
23/11/2017 - 10:22

OK OK

User
23/11/2017 - 10:23

sweet

Excelchat Expert
23/11/2017 - 10:23

, would you please me give a moment to solve your problem?

User
23/11/2017 - 10:23

yes my man

Excelchat Expert
23/11/2017 - 10:23

I’ll be back to you soon Thanks.

Excelchat Expert
23/11/2017 - 10:25

Check formulas please in Cells

Excelchat Expert
23/11/2017 - 10:26

Got it Sir?

User
23/11/2017 - 10:27

it isnt working in excel?

User
23/11/2017 - 10:27

cell comes back empty

Excelchat Expert
23/11/2017 - 10:27

No worry I'll upload an excel file here,please wait

User
23/11/2017 - 10:27

thankyou

Excelchat Expert
23/11/2017 - 10:27

Please one thing important in start please, when you Got solution please END this session & rate me 5 if you are satisfied,Thanks

Excelchat Expert
23/11/2017 - 10:28

[Uploaded an Excel file]

User
23/11/2017 - 10:29

ok thank you

User
23/11/2017 - 10:29

:D

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*