IF Formula

Wings

Member
Joined
Feb 13, 2015
Messages
34
Reaction score
0
Points
6
Excel Version(s)
2013
Can someone help?
I want to be able to return a figure under a salesman's column, but only if their initial's are in a cell, and if there is won under quote status column. I've tried IFs(H349=R349&IF,P349=T357,O349,""), but it doesn't seem to work. Any ideas?
 
Try

=IF(AND(H349=R349,P349=T357),O349,"")
 
Thanks very much, I've been puzzling over that and trying this and that.
It works
 
Hello again, how about a formula to return a figure with a % added on as a gp ie 100 would become 125.00 with 20% added as a GP?
 
Doesn't 100 with 20% added become 120?

=A"*120%
 
It does when you add it, but not as a GP. on a calculator I would divide 100 by 0.8 and get 125, which is 20%gp, how can I do that in excel
 
That would be

=A2/(1-20%)
 
Thanks for that, what I have is a column for a buying cost , next a cell where I can put what ever % I need, and return the figure with the % added as a GP, IE 100 in one cell, say 20% in the next with the result in the last one. Could you help? I really appreciate your help
 
Back
Top