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.