Formula for
Try this:
C1: IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid Entry")
Also, if you aren't already, you might want to use Data Validation on Cell
A1 to only allow M,C, or V.
Does that help?
€¢€¢€¢€¢€¢€¢€¢€¢€¢€¢
Regards,
Ron
"Andy JL" wrote:
Hi.
I want a formula to enter into a cell - if A1 is "M" then I want C1 to be
£8.00 or
if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I can
enter in Cell C1 to make display either £2.00 or £8.00 depending on wat is in
A1 -
Thanks for any help
Andy JL
|